I'm wanting to change a text box control that is bound to a query to bold during execution if certain criteria is met. I have been trying to do this in the Detail_Format section of the report with no success. I can't find a method for the textbox object to set the font weight or set the font to bold. I am using Access 2000.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Change text box to bold on the fly
- Thread starter btalon
- Start date
- Thread starter
- #2
PaulBricker
Programmer
Use the format event for the Detail Section. Then use a conditional statement to test for the value and change the FontWeight as necessary.
If Me.FieldName = SomeValue Then
Me.FieldName.FontWeight = 800
Else
End If
That should do it.
Paul
If Me.FieldName = SomeValue Then
Me.FieldName.FontWeight = 800
Else
End If
That should do it.
Paul
- Status
Similar threads
- Locked
- Question
- Locked
- Question
