Mixed Number Formatting

[acctguy]

I've got a report that has some numbers I would like to format as percentages and others I'd like just formatted as numbers. I found part of my solution in thread thread703-1214770 which tells me how to write the VB portion. But how do I link that script to my report.

 

[genomon]

Custom defined formats may be of help. Looks like:
Format(fieldname,"####") or Format(fieldname,"0.0%"), etc.
Good reference to this in Access help....

Did you hear about the Buddhist who refused Novocain during a root
canal? He wanted to transcend dental medication.

 

[acctguy]

Thank you. That info is very helpful. Do you know if there is a way to say if the value is less than 1 to format it as a percentage, otherwise format it as an integer? The custom formats in the help section just let you differentiate among positive, negative, zero, and null.

 

[genomon]

You could use the Immediate If (IIf) function:
IIf(fieldvalue < 1, Format(fieldname,"0.0%"), Format(fieldname,"####")).
Better check the formatting symbology in Access help, though - I'm just doing it from memory
Good Luck!

Did you hear about the Buddhist who refused Novocain during a root
canal? He wanted to transcend dental medication.