Conditional formating

[Richard]

Hi

I have a continuous subform with all the dates for the year. I would like to
have satudays and sundays with a different backcolor. How do I set it up?
The control is now formated as "ddd dd mmm yyyy".

Thanks in advance
Richard

 

[Brian]

Hi

I have a continuous subform with all the dates for the year. I would like to
have satudays and sundays with a different backcolor. How do I set it up?
The control is now formated as "ddd dd mmm yyyy".

Thanks in advance
Richard

Assuming you are using at least Access 2000:

Click on the data control (let's assume the field is called MyDate)
Choose Conditional Formatting from the Format menu
In Condition 1, choose "Expression Is" from the drop-down list
In the text box, enter the following expression: Weekday([MyDate]) In (1,7)
Open the Fill/Back Color palette and choose your desired colour.