Bold font for numbers more than -1

[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

 

[superhellaya]

Look into Conditional Formatting.

Lol thanks as well

 

[DHookom]

You can use code in the on format event of the report section to change the font size. Your code will also need to return the font to the regular size as needed.