How to make the Backcolor change

  • Thread starter Thread starter Chris Windsor
  • Start date Start date
C

Chris Windsor

What is the best way to have the back color of all input boxes on a form
change when the box is empty? My case is I have forms that have the back
colors set to yellow when the box is empty (highlighting it to the user),
and this goes to white when something is entered. The challenge is covering
for all the other events that can empty the boxes; e.g. navigate to another
recorde, record delete or undo changes.
 
Use the AfterUpdate and Undo events of each control to set the color.
Use the Current and Undo events of the Form to handle the record change and
unto.

The Undo events are not available in Acess 97 or earlier, and you need to
examine the OldValue of the control.
 
Back
Top