Format a text box in a sub-report

[Guest]

I am attempting to set the format of a text box in a sub-report to Percent.
When I click on Format in the properties, my pull down menu list is blank.
Typing in Percent does not work either. Changing the format in the query
that supplies the information does not work either. The field that I am
trying to format is an expression that divides the sum of one field by the
sum of another field with an IIF statement in case the denominator is 0. Any
suggestions?

 

[Duane Hookom]

Wrap your IIF() in the Val() function so you have something like
YourColumn: Val(IIf([FieldA]=0,0,[FieldB]/[FieldA]))