Don't display value if data source value = 0?

[Guest]

I have a form, whose data source is a a table-column. If a specific displayed
record has a zero (0) for a value, I want to show a <blank> instead of the
zero. I've been beating on this for awhile now, and have been unable to do it
successfully. If I create an unbound field in the form, and source or default
it using an IIF statement, it works fine, but DOES NOT update when the
records are stepped through (using GoToNextRec and GoToPrevRec methods).

Any ideas? I'm stumped.

Thanks!!

 

[fredg]

I have a form, whose data source is a a table-column. If a specific displayed
record has a zero (0) for a value, I want to show a <blank> instead of the
zero. I've been beating on this for awhile now, and have been unable to do it
successfully. If I create an unbound field in the form, and source or default
it using an IIF statement, it works fine, but DOES NOT update when the
records are stepped through (using GoToNextRec and GoToPrevRec methods).

Any ideas? I'm stumped.

Thanks!!

Using a regular bound control is fine.
Set it's format property to
#;-#;""

Look up in Access help:
Format property + Number and Currency datatype

 

[Guest]

Thanks! This was kind-of an emergency, hence my posting to two newsgroups.