Field Attributes

  • Thread starter Thread starter WWV
  • Start date Start date
W

WWV

I have a yes/no field in my table. On a report I would like to check this
field and if YES, print the NAME , ADDRESS field data in BOLD. (change the
attribute). I think maybe it's in SetValue but can't seem to find SetValue
options in help.
Thanks for any help.
WWV
 
In the OnFormat event of the detail put the following code.

Private Sub Detail_Format(Cancel As Integer, FormatCount
As Integer)
If Me.yes/no field = True Then
Me.Name.FontWeight = 700
Me.Address.FontWeight = 700
Else
Me.Name.FontWeight = 400
Me.Address.FontWeight = 400
End If
End Sub
 
Back
Top