Access Form Field BackColor Property 1

[DownwardSix]

I would like to program a form to change the BackColor of the current field. This can be done by going to each field and creating an Event Procedure for GotFocus & LostFocus on Each TextBox.

Can an Event Procedure be created in the Form GotFocus & LostFocus to change the BackColor for the selected TextBox. If so could someone post sample code.

Thanks in Advance.

DownwardSix

 

[sha76]

myTxtBox.BackColor = 8388863
(although you'll probably want another colour unless you're particularly fond of fuschia!)

Sharon

 

[BillPower]

Hi DownwardSix

You might start by looking at thread181-453702, if it's not what you're looking for, let me know.

 

[sstray]

Easiest way I have found to do this, is to use conditional format, under the format menu.

Set field has focus as the condition, then select a colour

 

[DownwardSix]

Thanks to all for the help!!! Bill Power's link to a past thread was exactly what I was looking for.

Thanks Again,

DownwardSix