Empty filed question

[outlaw318]

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]

Set the format of the control to
$#,##0.00[Black];$#,##0.00[Black];$0.00[White]
Or
$#,##0.00[Black];$#,##0.00[Black];" "

 

[outlaw318]

THat worked perfectly, thanks

 

[outlaw318]

It worked for the currency, but what about the numeric field?

 

[Rich]

Remove the Currency symbol

 

[outlaw318]

It didnt work when I tried it the first time, I used the other code and it worked. Thanks