Format Zero Percent to Show "-"

[GSCaupling]

I have a form field that is a percent. When I format as a Percent it allows whole numbers to be entered and still displays them as percentages (e.g., entering "25" results in "25%" rather than 2500).

However, when the value is zero I do not want to see "0". I would prefer to see see a hyphen or nothing at all.

I tried the format "[blue]#%;(#%)[Red];- ;-[/blue]" and it gives me the hyphen for zeroes. However, "25" now becomes 2500%.

Can't it do both? Can anyone advise of a custom format that displays zero values as a hyphen or blank while still allowing the user to input whole numbers without the decimal place?

Many thanks,
GS

[Green]******^*******
[small]I[/small] [small]Hate[/small] [♥] [small]Ambiguity.[/small][/green]

 

[dhookom]

I would probably use code in the after update that divides the entered value by 100 if the number is greater than a specific value.

Duane
Hook'D on Access
MS Access MVP

 

[GSCaupling]

Thanks Duane. I thought there might be an easier way, but I'll give it a shot. Some of the percentages are over 100, so this should be fun.

GS

[Green]******^*******
[small]I[/small] [small]Hate[/small] [♥] [small]Ambiguity.[/small][/green]

 

[MacroScope]

IIf([FieldName]=0," - ",[FieldName])