Change report font

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I need to change a font value of a report text field
based on its value in the database. For instance, if a
person's name is equal to "Smith" I want to change its
displayed font value to bold. Thanks.

Mike
 
Michael said:
I need to change a font value of a report text field
based on its value in the database. For instance, if a
person's name is equal to "Smith" I want to change its
displayed font value to bold.
Click to expand...

In the text box section's Format event procedure, use code
like:

If Me.txtperson = "Smith" Then
Me.txtperson.FontBold = True
Else
Me.txtperson \.FontBold = False
End if

where txtperson is the name of the text box bound to the
person name field.
 
Thanks Marsh, worked perfectly.
Mike
-----Original Message-----


In the text box section's Format event procedure, use code
like:

If Me.txtperson = "Smith" Then
Me.txtperson.FontBold = True
Else
Me.txtperson \.FontBold = False
End if

where txtperson is the name of the text box bound to the
person name field.
Click to expand...
 
Back
Top