IIf statement to change font to Bold

[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.

 

[Marshall Barton]

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.

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.

 

[Guest]

Thank you works graeat!

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.

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.