Conditional Formatting?

[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

 

[Marshall Barton]

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.

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