Conditional Formatiing- Date

  • Thread starter Thread starter Mike Mueller
  • Start date Start date
M

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
 
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.
 
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
 
Back
Top