Affect current instance of control in Continuous Form

  • Thread starter Thread starter Cory
  • Start date Start date
C

Cory

I have a Form set to continuous in Access 2003. If I want to change the
color via a sub executed from a command button which is replicated on each
record (i.e. it appears continuously also), how would I do so without haveing
the change applied to every instance of a control? If I have a text box
named txtMyTextBox and say
Me.txtMyTextBox.BackColor = RGB(128,255,128)

it changes all of the instances of txtMyTextBox that color instead of only
the one in the record on which I am currently working.

Any way around this? Any help is greatly apprecaited.
 
Cory said:
I have a Form set to continuous in Access 2003. If I want to change the
color via a sub executed from a command button which is replicated on each
record (i.e. it appears continuously also), how would I do so without
haveing
the change applied to every instance of a control? If I have a text box
named txtMyTextBox and say
Me.txtMyTextBox.BackColor = RGB(128,255,128)

it changes all of the instances of txtMyTextBox that color instead of only
the one in the record on which I am currently working.

Any way around this? Any help is greatly apprecaited.
Click to expand...


You need to use Conditional Formatting for this. To do that, there has to
be something about each record, or a function that can be called for each
record, that CF can evaluate to see whether to apply the formatting or not.
 
Back
Top