How do I change the background color of a cell when data is entered in

[aggieweld]

How do I change the background color of a cell when data is entered into a database record.

We have recently converted a spreadsheet schedule into Access, with queries and forms filtering out information appropriate to the individual users. When this information was in Excel the inidividual users were used to highlighting cells when they entered information into the individual cells to visually show completion.

Is there a macro, or events procedure that would allow the individual field record to change in background color when data is entered for the first time or from null value to not null value. That would then duplicate the way we were using Excel.

Thanks....

 

[zemp]

First off, welcome to Tek-Tips. Take the time to read faq222-2244 on how to get the best results form these fora.

Back to your question, this would be a question for one of the MS Access forums and not a general discussion forum. Try forum702 or forum181. You can check the forum list, in the upper left box, for a complete list.

Take Care,

zemp

"Show me someone with both feet on the ground and I will show you someone who can't put their pants on."