Conditional formating

R

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
 
B

Brian

Richard said:
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
Click to expand...

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.
 
Top