conditionally changing back color, how to?

S

SF

Hi
I have a timesheet report that display 1 - 30 days in a month. Is there a
way to change back color to gray for Saturday and Sunday column (or may be
other holiday)?

I use access 2003.

SF
 
D

Duane Hookom

Yes this can be done. You might be able to use code or conditional
formatting. It would help to know what your field names are and how you
might determine which controls are bound to weekend dates.
 
S

SF

Hi,

My report is based from a crosstab query.

ID Name 01/03/2006 02/03/2006 03/03/2006 ETC..
23 xyz 7.5 7.5 7.5

I want to set back color to gray if the date fall under Saturday or Sunday.
How would conditional formatting help in this case?
 
D

Duane Hookom

You can use code to check the control source to convert it from text to a
date and find out if it has a WeekDay() value of 1 or 7 to set the back
color to gray.

Duane Hookom
MS Access MVP
 
Top