Newbie question

[Maggic]

I have a price field defined as integer, fixed format, with 2 decimal
places. I would like this to be blank on the report when the value is zero,
instead of displaying 0.00 as it currently does ..

Some help with this would be much appreciated, and apologies for the dumb
question

Maggic

 

[Steve Schapel]

Maggic,

Set the Format property of the textbox on the report design to...
#.00;\-#.00;
Note that you will need to type a space after the final ; for this to
work.
The principle here is that the first segment will define the format of
positive numbers, the second segment for negative numbers, and the
third segment for zeroes.

By the way, was your description correct... integer with 2 decimal
places? All your proces in whole dollars but all to show the .00 on
the end?

- Steve Schapel, Microsoft Access MVP

 

[Fredg]

Maggic,
Are you aware that a field of Number datatype Integer will never hold a
decimal portion? By definition, an integer is a whole number.
If you require decimals, change the field to Currency datatype.

 

[Maggic]

Thanks for you reply ... I have changed the "field Size" to "Single" to show
the 2 decimal places correctly, but am still having trouble displaying
blanks when the price is zero. The format property of the textbox for Price
on the report will only allow me to select "currency, fixed ... " etc.

Sorry to be so dumb about this ... my first time doing reports in Access ..
also my first attempt at an Access data base .. that's my excuse and I'm
sticking to it

Your help is most appreciated.

Maggic

 

[Maggic]

I will do that .. many thanks to both of you, Steve & Fred for your help it
is much appreciated .. .

Maggic

 

[Maggic]

I typed the expression you gave and still get ".00" showing when the field
is zero .. I also tried "#.##;" (there will never be negative nos in this
field) and got the same result .. my understanding of using the digit (#)
placeholder is that it will display a digit or nothing, but that doesn't
seem to be the case .. am I missing something?

Maggic

 

[Maggic]

Yippee .. that worked ... many thanks for your time and patience ...

Maggic