2

In Access is it possible to change the caption of a button based upon a text box control that is displayed on a continuous form?

I'd also like to enable and disable the button on the continuous form depending upon the value in the record's text box control.

I've tried on the OnCurrent form property but that takes the values of the first record of the continuous form and sets all buttons on the continuous form based upon that rather than setting the buttons on the continuous form for each record.

Fionnuala
  • 90,370
  • 7
  • 114
  • 152
icweb
  • 57
  • 2
  • 4

2 Answers2

1

Unbound controls on a continuous form can only refer to the current record. It may be possible to bind the control in some way. You can use conditional formatting to do a variety of quite interesting things.

Fionnuala
  • 90,370
  • 7
  • 114
  • 152
0

Try setting the caption in the Detail_Paint event for the form: 

cb_SetSpecies.Caption = [Species_Name]

This allows a different value to be set for each record.

dldnh
  • 8,923
  • 3
  • 40
  • 52
southy
  • 1