Highlight dates

[jk12]

Hi all. Within my report, is there a way to highlight the date fields that would be either a saturday or sunday in grey for example so that weekdays are shown more clearly. Note that I have already set the date fields to read Mon, Tues, Wed etc but for some people using my database this doesn't seem to be enough.

Any help please.

 

[GohDiamond]

Use Conditional Formatting check the MS Access help file:
"Apply or change conditional formatting on a control"

Goh

 

[Rickster57]

days

There are a few ways to do this. You could use the On Print of the Details section of your report to read:
If [theday]="Saturday" or [theday]="Sunday" then
[theday].forecolor=whatevercoloryouwant
else
[theday].forecolor=blackorwhatevercolor
end if

 

[jk12]

I have tried both methods and can't get it to work. What am I doing wrong.

I have a text box with the Date() expression in it then Date() + 1 for tuesday, Date() + 2 for wednesday etc and then within each text box set the format for them to dddd so that they show Monday, Tuesday etc instead of 08/01/2007 etc. Is this affecting my problem in anyway?