On Sat, 11 Sep 2004 18:51:35 +0200, jj wrote:
Hi
I have a report based on a table with some columns with numbers.
Now my problem is that when I display the columns in my report there is a
zero a lot of places, and I would rather want to display blanks instead of
zero. Can anyone tell me how to do that?
Thanks
jj
Depending upon how you want the positive and negative numbers
formatted, set the format property of the control to:
#;-#;
or..
#,###;-#,###;
or..
#,###.00[Black];(#,###.00)[Red];
etc.
See Access Help
Format Property + Number and Currency Datatypes
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.