Format() BUG!?

[Zvonko]

Hello!

I have one annoying problem with Format() function.
I retrieve records from DB and if value of field is 0, the Format() function returns me ".00". Here's the code I use:

Format(!Qty, "##,###.00")

This is annoying, because if I print the value Format() returns, it's printed just ".00".
Any suggestions?

[HeSaidJoe]

What do you want to get"
The format function is giving you what you ask for.
If you want 0 then
dim x
x = Format(!Qty, "##,###.00
if x = ".00" then x = "Whatever"

[d.paulson]

Is this what you want?
Format(!Qty, "##,##0.00")

[Zvonko]

YES! That was what I was looking for.
Thanks!