Conditional Formatiing- Date

[Mike Mueller]

I have a report with a group header of date in a mmmm/yy
format. I would like to do a cond-format on here so that if
the date is before today then bold/color change etc. I just
cannot get it to resolve the first part correctly, it either
highlights none or all

Mike

 

[Fredg]

Mike,
If you have Access 2000 or later use the conditional formatting property.

Click on the date field.
Format + Conditional Formatting
In the Condition 1 drop-down box select
Expression Is

In the text box alongside the drop-down, write
[DateFieldName] < Date()
Click on the Bold tool button, and then select a color from the color
selector.
Click OK.

If you have Access 97, see if
http://www.lebans.com
has something for you.

 

[Mike Mueller]

Thank you Fred-
It worked like a charm (A2000)

Mike


: Mike,
: If you have Access 2000 or later use the conditional
: formatting property.
:
: Click on the date field.
: Format + Conditional Formatting
: In the Condition 1 drop-down box select
: Expression Is
:
: In the text box alongside the drop-down, write
: [DateFieldName] < Date()
: Click on the Bold tool button, and then select a color
: from the color selector.
: Click OK.
:
: If you have Access 97, see if
: http://www.lebans.com
: has something for you.
:
:
: message :: I have a report with a group header of date in a mmmm/yy
:: format. I would like to do a cond-format on here so
:: that if
:: the date is before today then bold/color change etc. I
:: just
:: cannot get it to resolve the first part correctly, it
:: either highlights none or all
::
:: Mike