Making a field in a single record bold

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On a form I want to display a price field in bold if it is zero.
I have tried the following code in the AfterUpdate event of the field but
have found that the prices on all the displayed records change to bold not
just the one that is zero.
If Me.Price = 0 Then
Me.Price.FontBold = True
Else
Me.Price.FontBold = False
End If
Can anyone suggest how to get just the zero record in bold?
 
Open the form in design view, select the field, and from the menu bar select
Format > Conditional formating.

You can select the value and the way you want this field to be displayed for
that value
 
You are OK with the code, but you also need to put the same code in the On
Current Event for the form.
 
Thanks - this has done what I wanted.

Ofer said:
Open the form in design view, select the field, and from the menu bar select
Format > Conditional formating.

You can select the value and the way you want this field to be displayed for
that value
Click to expand...
 
Back
Top