Field color for input

[wthoffman]

How do I have the field in a form that is to be filled in change color when
the pointer is on the field as a result of tab or mouse movement?
Thanks,

 

[Jeanette Cunningham]

Hi wthoffman,
one easy way is to make the controls have a color that is different from the
backcolor of the form and then set the contols to be transparent.
If a control is transparent, when it has the focus, it shows the normal
backcolor. When the focus leaves the control, it returns to the transparent
state.


If you wish to use code to change the color, have a look at this
http://allenbrowne.com/highlight.html



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[John Spencer]

You can use conditional formatting to do this.

In design view
== Click on the control
== Select Conditional Formatting from the format menu
== Change Field Value Is to Field has Focus
== Click on the Paint Bucket and choose a back color
== Click OK

If you need to do multiple controls, then you can click on the control you
have just set up and then double-click on the format painter button (paint
brush icon) in Access 2003 and earlier. This will copy the format for the
control and stay active until you click on the Format Painter button again.

Now click on each control that you want to have the conditional formatting you
have just set up.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County