Conditional Formatting?

  • Thread starter Thread starter swagner via AccessMonster.com
  • Start date Start date
S

swagner via AccessMonster.com

I am not an experienced Access 2007 user so this may be an easy one.

On my reports I want certain lines to be bold depending on certain criteria.

The criteria is basically: If Date A is before Date B AND the difference
between Date B and Date A is less than 3 years then I want that record in
bold type.

Can this be done? The dates are in my query that my report references. Do
the dates have to be part of the report. I have used advanced filtering on
fields not in the report and it works so I hope I don't have to include them.

Thanks
Scott
 
swagner said:
I am not an experienced Access 2007 user so this may be an easy one.

On my reports I want certain lines to be bold depending on certain criteria.

The criteria is basically: If Date A is before Date B AND the difference
between Date B and Date A is less than 3 years then I want that record in
bold type.

Can this be done? The dates are in my query that my report references. Do
the dates have to be part of the report. I have used advanced filtering on
fields not in the report and it works so I hope I don't have to include them.
Click to expand...


Unless things have changed dramatically, the report does
need to have a (hidden?) text box bound to the fields that
you want to use in a VBA procedure, Condifional Formatting
or Sorting and Grouping.

You can then use CF to bold certain text boxes by using a CF
expression like:
[date A] < [date B] And DateDiff("m",[date A],[date B])<36
 
Back
Top