How to get blanks in stead of zeros and kommas ? (format property)

[griet]

I do have a currency-field dat doesn't have always a value. I know how I can use the format property to get blanks when the value of the field is zero.
I do have the following on the format property :
#.##0,##;#.##0,##; ;

but when the value of the field is f.i. 6000 then i get
6000,
on the report and I want
6000
thanks already for help

 

[JoeMiller]

0;-0;;

Try that Joe Miller
joe.miller@flotech.net

 

[griet]

yes, thank you , but in that case decimal numbers are rounded : f.i. I get 11 in stead of 10,78

 

[JoeMiller]

0.0;-0.0;; Joe Miller
joe.miller@flotech.net

 

[griet]

than you get 6000.0 in stead of 6000

 

[griet]

Thanks anyway but I 'll make myself clear :

I want for one field :
6000 (no decimal point and no zeros)
11,25 (as many decimal places as needed)
(blanks) (if the value is zero, I want blanks)

is this possible do you think ?

 

[Lightning]

Try

####;#,##0.###; ; ;

HTH
Lightning

 

[griet]

Dear lightning, I'm afraid it is not working the way I want.

When you put "general number" in the format property of the field, it is exactly working the way I want, except that I can't ban the zero-values ...

In your proposal 11,25 is printed as 11

thank you

 

[griet]

Hello,


I don't know if it is the right way to do , but I solved my problem with the conditional formatting tool, which is new in access 2000 : I formatted the field in the ordinary way and gave it a contional format in case the field is zero : color of the font and background : same color , so you don't see it ...

my problem is solved, but is this the right way to do ?