I need to create a report that disp

[atadbitslow]

I need to create a report that displays address changes. But the trick is I need to have the field(s) that changed appear in bold.

Any ideas? Thanks!

 

[ScottCybak]

Ok, when you say you want to format changed address, i'm assuming that you either have one of the following.

A - a second address field
b - a yes/no field that reflects changes

Regardless, in the detail section of the report, in the onFormat event, modify my code to reflect your fields:

'Case a:
If Me![AddressField1] = Me![AddressField2] Then
    Me![State].FontWeight = 700
Else
    Me![State].FontWeight = 400
End If

'Case b:
If Me![NameOfYesNoField] = -1 Then '-1 stands for true
    Me![State].FontWeight = 700
Else
    Me![State].FontWeight = 400
End If

And, straight from the help files in access, here's the weight coversions

Thin 100
Extra Light 200
Light 300
Normal 400
Medium 500
Semi-bold 600
Bold 700
Extra Bold 800
Heavy 900

This is basically like conditional formatting.. HTH