-
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:
Code:
Format(!Qty, "##,###.00")
This is annoying, because if I print the value Format() returns, it's printed just ".00".
Any suggestions?
-
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"
-
Is this what you want?
Format(!Qty, "##,##0.00")
-
YES! That was what I was looking for.
Thanks!