Infinity - Sigma - %'s TOO Big

[Freckles]

There are times when a persentage comes out just too big (or too small) to be meaningful. What has anyone used to avoid this problem? Is there a way to insert "sigma" or some other character when the need arises?

It should be able to be done with a report IIF statement if I could just know what to use when "true" : Deb Koplen
deb.koplen@verizon.com

A person can stand almost anything except a succession of ordinary days.

 

[mdthornton]

I've often customized control on reports like this by converting them to strings, eg, set the control source to:

=iif([mypct]>1000, &quot;big_text&quot;, iif([mypct]<0.001, &quot;small_text&quot;, format([mypct], &quot;0.00%&quot))

If you're feeling adventurous you could set up 3 controls on top of each other, normal, small & big say with control sources respectively of:

=iif([mypct]<1000 and [mypct]>0.001, [mypct])
=iif([mypct]<0.001, &quot;S&quot
=iif([mypct]<0.001, &quot;X&quot

Now set the can shrink property to yes. This has the effect of only showing one control depending on which condition is met. If you change the font of the small control to Symbol you should see a Sigma for small values. I couldn't figure out how to get the infinity symbol though, haven't got time to explore this right now but I'm curious....
Best Regards,
Mike