Don't display value is 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!!

Answered elsewhere.
Please do not multi-post. If you feel you must post the same question
to more than one newsgroup (and it's seldom necessary), cross-post by
adding each additional newsgroup in the To Newsgroups: box, separated
by a comma.
This way an answer in one newsgroup will be seen in each of the
others. More readers will see the response and learn, and less time
will be spent on duplicate answers.

See Netiquette at http://www.mvps.org/access

It's a great site to visit anyway.