Affect current instance of control in Continuous Form

[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.

 

[Dirk Goldgar]

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.

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.

 

[Cory]

Alrighty, no problem. I guess I was just overthinking it.

Cory