I have an access report with currency values. In the records that are $0.00 I would like the fields to be blank. How can I do this?

You can display them as blanks using the following

=IIf([FieldName]=0,"",[Fieldname])

You could aslo do it via vba code and hide this control using the visible property.

HTH
Ken

Can you show me how I would do this with VBA?

Thy this:

...
If Not [FieldName] Then
Me.ControlName = Null
Else Me.ControlName = [FieldName]
End If
...


NOTE: The control should not be the same name as the field nor should it be bound to the field.

I had to use the first option and I put the code in the query for the report. The values are correct but I cannot format it. I can't select currency and when I type it in, it doesn't do anyting.

Here is the code from the query, H1reva: IIf(tblrevcomp.h1rev=0,"",tblrevcomp.h1rev).

Do I need to use some format command and if so, where do I put it?

Thanks

Marshall

Ok, here is the solution.

When there is Null value in table then I need to print --- in place of it.

For this, in design window of the report.
select the text box
go in the properties of it
in format, write like 0,00;;;-- (in your case, it will be 0,00;;; )

Thanks for the help.

My format command looked a litte different after I entered it,

#,##0.00;;""

The #,s appeared after I entered the text you recommended and the like wouldn't work.

Thanks again for the help. It all works properly now.

Marshall

glad to know that the small hint gave you an idea (IMG:http://www.utteraccess.com/forum/style_emoticons/default/frown.gif)