format date in a report

[Guest]

I have a report the has two columns of data. the first column is the date in
long format and the second column is a dollar amount. I would like to have
the weekends be a different color that the rest of the week. Can anyone help?

thank you

 

[Allen Browne]

Assuming Access 2000 or later, use conditional formatting:

1. In report design view, select the text box you want to change color.

2. Choose Conditional Formatting from the Format menu.

3. Chose: Expression
(Weekday([MyDateField]) = 7) Or (Weekday([MyDateField]) = 1)
replacing MyDateField with the name of your date field.

4. Click the color you want when this expression is true.