Change fields background color after data entry

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

I would like to have the field on my date entry form change to a specfic
color after data is entered. Right now all the fields background are white. I
would like them to be light green, for example after data is entered and
saved.

Can this be done without me know how to write codes? Is there a simple
code/script that I can copy and use to make this happen?

Thanks.
 
Joe,
you can use conditional formatting to do this.
Look on the format menu | Conditional formatting.


Jeanette Cunningham -- Melbourne Victoria Australia
 
The easiest way is to use Conditional Formatting - Format, Conditional
Formatting.
Then change the dropdown box to "Expression Is" and type in MyField is
Null and then choose your desired formatting.
Darrell
 
Thank you, Jeanette.

Jeanette Cunningham said:
Joe,
you can use conditional formatting to do this.
Look on the format menu | Conditional formatting.


Jeanette Cunningham -- Melbourne Victoria Australia
Click to expand...
 
Thanks for your response, Darrell.

Darrell Childress said:
The easiest way is to use Conditional Formatting - Format, Conditional
Formatting.
Then change the dropdown box to "Expression Is" and type in MyField is
Null and then choose your desired formatting.
Darrell
Click to expand...
 
Back
Top