Bold font for numbers more than -1 (1 Viewer)

[turniporange23]

On my subform of my report I am trying to force access to give numbers more than minus 1 and bold font
Is this possible?
This is the control source to the text box
=IIf([Flag]=0,[AmountSummary],"(" & Format([AmountSummary],'$#,##0.00;$#,##0.00') & ")")
Thanks for any help................Bob

 

[tvanstiphout]

Look into Conditional Formatting.

 

[turniporange23]

Thanks Tom that did the trick

 

[turniporange23]

Well nearly did the trick, I am trying to get tbInvoiceAmount to drop its font from 9 to 8 if tbFlag is -1
Conditional Formatting has no option of reducing the text size, Any Thoughts...........Regards Bob