BackColor issue

[wh00t]

greetings all

I have created a form (continuous view) based on a query, each record contains a date field. If this time is more than 12 hours ago I wish to change the background colour of the fields. I have the code in the form load event which works fine but due to the form being a continuous form if the first record is over 12 hours all records change colour and if the first record is less than 12 hours all records remain the standard colour.

Is there any way using a continuous form that I can change the background colour of individual records?

 

[ghudson]

Access 2000/2002/2003 has the Conditional Formatting feature. Check the help files or search here for more details.

 

[ray705]

I don’t remember where I got this example, but I believe it is what you are looking for.