IIf statement to change font to Bold

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

Guest

Access 2000. I have a report that shows [Bond], [Credits], [Debits] and
[Balance]. The underlying query for [Blance] is =[Credits]-[Debits]. What
I would like is for the fonts in the textbox [Balance] to change to BOLD
when [Balance] exceeds the amount of the textbox [Bond]
Example: [Bond] shows $1000.00, the [Balance] shows $1200.00. in this
case the balance should be in bold font, otherwise it will be normal font.
Is this possible? Thanks, Randy.
 
Access 2000. I have a report that shows [Bond], [Credits], [Debits] and
[Balance]. The underlying query for [Blance] is =[Credits]-[Debits]. What
I would like is for the fonts in the textbox [Balance] to change to BOLD
when [Balance] exceeds the amount of the textbox [Bond]
Example: [Bond] shows $1000.00, the [Balance] shows $1200.00. in this
case the balance should be in bold font, otherwise it will be normal font.
Click to expand...


Use Conditional Formatting (Format menu) for the textbox.
Select the Greater Than operator and set the last box to
[Bond]. You can then select the Bold format.
 
Thank you works graeat!

Marshall Barton said:
Access 2000. I have a report that shows [Bond], [Credits], [Debits] and
[Balance]. The underlying query for [Blance] is =[Credits]-[Debits].
What
I would like is for the fonts in the textbox [Balance] to change to BOLD
when [Balance] exceeds the amount of the textbox [Bond]
Example: [Bond] shows $1000.00, the [Balance] shows $1200.00. in this
case the balance should be in bold font, otherwise it will be normal font.
Click to expand...


Use Conditional Formatting (Format menu) for the textbox.
Select the Greater Than operator and set the last box to
[Bond]. You can then select the Bold format.
Click to expand...
 
Back
Top