Conditional Format Continuous Form

[JimS]

I am listing a bunch of sequential dates in a continuous forms form. I want
weekend dates to be sort of "greyed out". Having trouble with this one...can
you help?

 

[John W. Vinson]

I am listing a bunch of sequential dates in a continuous forms form. I want
weekend dates to be sort of "greyed out". Having trouble with this one...can
you help?

You could use a conditional format with an Expression

Weekday(Date()) = 1 or Weekday(Date())=7

and set the background color of the date textbox to something greyish.

 

[JimS]

Using A2007.
I may have left the wrong impression. If the date on the row is a sat or
sun, I want it to "grey" out (I can handle the actual setting of the
properties...), but if I use an expression, it'll be referring the the
*Current* row, as opposed to formatting each row independently...

 

[John W. Vinson]

Using A2007.
I may have left the wrong impression. If the date on the row is a sat or
sun, I want it to "grey" out (I can handle the actual setting of the
properties...), but if I use an expression, it'll be referring the the
*Current* row, as opposed to formatting each row independently...

You're mistaken. The expression will refer to the row which is being
displayed. Try it.

 

[JimS]

John, I'll accept that I'm completely full of cr*p (it's happened before...),
but when I refer to the date, do I refer to the text box containing it, or
the "Me.DateColumn" reference to the form's control source recordset?

 

[Banana]

John, I'll accept that I'm completely full of cr*p (it's happened before...),
but when I refer to the date, do I refer to the text box containing it, or
the "Me.DateColumn" reference to the form's control source recordset?

Though there are definitely differences between a field and a control
(and the fact that Access deign to name control after the field doesn't
help the matter at all but I digress), for most parts reference to
either values will work. (There may be times where you need to
specifically refer to one or other, but this isn't a case where this
actually matter)

Conditional format is just "special" in that it works for each row
individually, unlike other cases like using unbound controls.

As John said, try it.

 

[John W. Vinson]

John, I'll accept that I'm completely full of cr*p (it's happened before...),

nah. There's a lot of wierd stuff in Access; I certainly don't know all of it,
I find surprises like this all the time.

but when I refer to the date, do I refer to the text box containing it, or
the "Me.DateColumn" reference to the form's control source recordset?

Either.