outlaw318
10-21-2003, 12:14 PM
I am creating a report with several fields that wil be empty. The problem is that most of these fileds are currency or numeric. When these fields are empty it shows a 0 in the numeric or $0.00 in the currency. Is it possible to keep this fields empty?
Set the format of the control to
$#,##0.00[Black];$#,##0.00[Black];$0.00[White]
Or
$#,##0.00[Black];$#,##0.00[Black];" "
outlaw318
10-21-2003, 01:26 PM
THat worked perfectly, thanks
outlaw318
10-22-2003, 06:34 AM
It worked for the currency, but what about the numeric field?
Remove the Currency symbol
outlaw318
10-22-2003, 11:49 AM
It didnt work when I tried it the first time, I used the other code and it worked. Thanks