Bolding only $ entered on a form to a report

[murk]

I have a report with Premium Payments on it that are called 1, 2, 3, 4a, 4b, etc. and are set as currency which automatically enters $0.00 when there is no amount entered. I want to be able to enter an amount on the form so that when it shows up on the report it is in bold so it stands out from the $0.00.

Please be very specific in your answer as to where and how to do this.

Thanking you in advance.

 

[PaulF]

Add code to the Report's Detail On Format Event. Add an IF statement for each TextBox control that is bound to the Fields you want to be bold to check the value and set the FontBold property accordingly. Example txt4 is bound to Field 4 you'd use

If txt4<> 0 then
txt4.FontBold = True
Else
txt4.FontBold = False
End If

and do this for each TextBox you want to alter

PaulF