Help date greater than 14 to change colour

[hullstorage]

Hi all
i looking for a way to change a fields color
so say if booking date and todays date is greater than 14 days old
then the field will display as red and the other as normal

help please it driving me nuts

thanks

simon

 

[Kempes]

if you have anything above access 97 then you have a conditional formatting option.

This is your solution. Otherwise, you will need to vb code it.

 

[Oldsoftboss]

Conditional formatting is the way to go.

The image attached shows how I format a field to:
1. Turn yellow when it has the focus (I do this for ALL fields, so the user can easily tell where the cursor is on the form.)

2. Turn orange when the date is within the next 31 days.

3. Turn red when the date is in the past.

Not sure what you mean by "booking date and todays date is greater than 14 days old", but the order the formatting is listed is important. Once a condition is seen to be true, the formatting is exited.

Dave