Format a text box in a sub-report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FMP - 24 Feb 2005 19:11 GMT

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?

Reply to this Message

Duane Hookom - 24 Feb 2005 20:19 GMT

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

Signature

Duane Hookom
MS Access MVP
--

>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.
[quoted text clipped - 4 lines]
> Any
> suggestions?

Reply to this Message