Conditional Formatting

[tomco22]

Access 2000

I have a list of dates and data on my subform. I want to visually delineate the end of one week with the beginning of the next week. It would be nice to have the background shading alternate from week to week but I have decided that is probably not possible.

What I’ve settled on instead is to have a heavy line separate Saturday from Sunday. I am using a text box for my line. I have tried conditional formatting when the [Date] value = “Sat” (format set to “ddd”). I have also tried conditional formatting when the [Date] value = “7” (format set to “w”). Neither works. I assume neither works because the underlying control source is “Short Date” rather than string or integer. Neither Cstr([Date]) nor Cint([Date]) works either. Is there any way to overcome this issue?


Tom
MCSD
I Nab Terrorists

 

[MacCaillean]

Hi Tom

Conditional formatting on a continuous form is not straightforward.

See

http://www.mvps.org/access/forms/frm0024.htm

for pointers.

Hope this helps

Mac

 

[RoyVidar]

I'm not entirely sure of locale, could be you ned testing for 1, 6 or 7, use expression is with your dateexpression, and an expression like this?

[tt]weekday([yourdatefield])=7[/tt]

Roy-Vidar