Conditional formating

[Guest]

Hi All,
Simple one this, though I cannot work it out lol.

I have a continuous form with dates of the month down one side, what I would
like to do is have the conditional format set up so if the date in question
is a Sat or a Sun the conditional formating will change the background
colour.

I know its the Expression is option and would utilize the DayOfWeek in the
expression somewhere but i keep getting a error when i try, can anyone help
me please.

Mike J. Soames

 

[Arvin Meyer [MVP]]

Try:

Weekday([ContractDate])=6 Or Weekday([ContractDate])=7
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Thanks Arvin,
Did a bit of searching and found the following which works also

Weekday([DT_Day],7)<=2

Thanks again

Mike J. Soames

Try:

Weekday([ContractDate])=6 Or Weekday([ContractDate])=7
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

Hi All,
Simple one this, though I cannot work it out lol.

I have a continuous form with dates of the month down one side, what I would
like to do is have the conditional format set up so if the date in question
is a Sat or a Sun the conditional formating will change the background
colour.

I know its the Expression is option and would utilize the DayOfWeek in the
expression somewhere but i keep getting a error when i try, can anyone help
me please.

Mike J. Soames