Text box colours

[Lyncroft]

I've a form and I want to make the background colour for each text box change when it's active. I know I can change the on enter and on exit properties for each box but is there a quicker way of doing it.

Thanks in advance

 

[Jeff Bailey]

There is a simple of way of highlighting the active control on a
form:

Set the background colour (Back Color) of the fields to, say, yellow.

Now make the Back Style transparent.

Now, when the control receives the focus its background will be yellow.

 

[Graham T]

Lyncroft

The following thread also contains an alternative aproach to Jeff's. I've tested this and it appears to work ok.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=17808&highlight=for+each+ctrl

HTH

Graham