Highlighting records in a continuous form

[Michaelcree]

Hello

Can anybody please advise?

I have a database running on a SQL server with Access as the front end. The table is displayed and accessed as a continuous form. One of the fields in the table is a date. I need to check this date and if it is more than 30 days old change the colour of the record on the continuous form.

I have looked at Conditional formatting but cannot work out the options to put in to make this work.

My question is does anybody have any idea how I can do this either using Conditional formatting of using VBA code?

Many Thanks for your help in advance

 

[lupins46]

if it is more than 30 days old change the colour of the record"

You can't change the colour of the record. You can change the colour of a control. So you have to put an empty textbox control on the form which is the same size as the form. You can then send this to the back (format menu) and you can conditionally format it using the date field value.