Using info from a Query.

  • Thread starter Thread starter Dale Olberding
  • Start date Start date
D

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.
 
Dale said:
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.
Click to expand...

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