Using info from a Query.

[Dale Olberding]

I am in the process of setting up a report in access and in the details line
I would like something to be bold based on the value of a field in a query.
i.e. If $ > 500 I would like the customer to be bold. I can do this in
Crystal Reports, but I am having trouble in access.

If anyone could point me in the right direction, I would appreciate it.

 

[Marshall Barton]

I am in the process of setting up a report in access and in the details line
I would like something to be bold based on the value of a field in a query.
i.e. If $ > 500 I would like the customer to be bold.

Couple of ways, in A2K or later, you might be able to use
Conditional Formatting (on the Format menu).

In all version and for more versatility, you can use code in
the detail section's Format event procedure:

If Me.txtsomefield > 500 Then
Me.txtsomefield.FontWeight = 700 'Bold
Else
Me.txtsomefield.FontWeight = 400 'Normal
End If