A Font Question

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

Guest

Does anyone know how to write an expression that will cause a value to become
bold if it enters the negative. For example, if I have a dollar value in a
text box, and it goes into the negative, is there a way to make it become
bold automatically? Thanks.
 
Try placing this code in your form's "On Current" event:

If Me.YourTextName < 0 Then
Me.YourTextName.FontBold = True
Else
Me.YourTextName.FontBold = False
End If
 
Or use Conditional Formatting if the ACCESS version supports it.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Anyone know what size font is in general use on this forum? 5
Concantenate which keeps bold of some parts. 5
Word Removing unwanted "lines" within a MS Word 10 table 1
Selecting a Yes/No datatype in datasheet view 3
Removing unwanted "lines" within a MS Word 10 table 2
Formatting text within Expressin Builder on a Report 4
Font Styles Not Showing Up 3
Outlook Outlook 2007 Font 0

Back
Top