Help Pls ? Continuous Form Forecolor change

[Matt Spoljarevic]

I have a Continuous form of which one of the controls is named “Workorderâ€.
This form lists all our current workorders, one under the other down the
page.

I would like to be able to change the forecolor of this control when it Gets
Focus. I have done this simply using

me.workorder.forecolor = 255

But obviously this changes all the “Workorder†controls listed on the form
at the same time.

Is there any way to only have it change the colour of only the specific
Workorder control that has focus ?

(Using Access 2007)

Any help would be greatly appreciated

Thanks in advance

Regards

Matt

 

[Marshall Barton]

I have a Continuous form of which one of the controls is named “Workorder”.
This form lists all our current workorders, one under the other down the
page.

I would like to be able to change the forecolor of this control when it Gets
Focus. I have done this simply using

me.workorder.forecolor = 255

But obviously this changes all the “Workorder” controls listed on the form
at the same time.

Is there any way to only have it change the colour of only the specific
Workorder control that has focus ?

(Using Access 2007)

Use Conditional Formatting (Format menu) on the text box.
There's an option for currently has the focus if that's all
you need.