View Full Version : Empty filed question


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?

Rich
10-21-2003, 01:06 PM
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?

Rich
10-22-2003, 11:13 AM
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