Format Access to show 0 like accounting in Excel

[waffle]

Is there any format that will allow a 0 to show as a - instead. It would be very useful for the situation that has arisen for me.

 

[The_Doc_Man]

In reports and forms, you can make the value of the control equal to something like...

iif( [Var]=0, "-", Str$([Var]) )

Also works in queries.

Doesn't belong in tables even as a format of a proper field. Tables should ALWAYS show reality.