Conditional formating - repost

R

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
 
R

Richard

Thanks Arvin

Appreciate it

RIchard

Arvin Meyer said:
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 said:
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
Click to expand...
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
Click to expand...
Click to expand...
 
R

Richard

Hi Arvin

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

Richard

Arvin Meyer said:
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 said:
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
Click to expand...
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
Click to expand...
Click to expand...
 
R

Richard

Manage to solve it

Thanks again Arvin

Arvin Meyer said:
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 said:
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
Click to expand...
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
Click to expand...
Click to expand...
 
Top