Conditional formating - repost

[Richard]

Hi All

I posted this message on the 7th. but I can't seem to find it when I
downloaded the messages today. So the repost.

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

 

[Arvin Meyer]

Set the conditional formatting to "Expression Is" then use the following
expression for Saturday:

Weekday([DateField])=7

and:

Weekday([DateField])=1

for Sunday
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Richard]

Thanks Arvin

Appreciate it

RIchard

Set the conditional formatting to "Expression Is" then use the following
expression for Saturday:

Weekday([DateField])=7

and:

Weekday([DateField])=1

for Sunday
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Hi All

I posted this message on the 7th. but I can't seem to find it when I
downloaded the messages today. So the repost.

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

 

[Richard]

Hi Arvin

Thanks for replying. But it doesn't seem to work..

Richard

Set the conditional formatting to "Expression Is" then use the following
expression for Saturday:

Weekday([DateField])=7

and:

Weekday([DateField])=1

for Sunday
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Hi All

I posted this message on the 7th. but I can't seem to find it when I
downloaded the messages today. So the repost.

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

 

[Richard]

Manage to solve it

Thanks again Arvin

Set the conditional formatting to "Expression Is" then use the following
expression for Saturday:

Weekday([DateField])=7

and:

Weekday([DateField])=1

for Sunday
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Hi All

I posted this message on the 7th. but I can't seem to find it when I
downloaded the messages today. So the repost.

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