Conditional Format Continuous Form

  • Thread starter Thread starter JimS
  • Start date Start date
J

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?
 
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?
Click to expand...

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.
 
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...
 
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...
Click to expand...

You're mistaken. The expression will refer to the row which is being
displayed. Try it.
 
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?
 
JimS said:
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?
Click to expand...

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, I'll accept that I'm completely full of cr*p (it's happened before...),
Click to expand...

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?
Click to expand...

Either.
 
Back
Top