Printing Blank instead of Zero or 0

[FA]

I want print blank (Nothing) if the value of the field is 0. In my
query i have a field
Select dbo_FINDG_RSK_LVL.FINDG_RSK_LVL,
Count(dbo_FINDG_RSK_LVL.FINDG_RSK_LVL) AS CountOfFINDG_RSK_LVL From
dbo_FINDG_RSK_LVL

Now in the report i there is no count its printing 0 but i want to
leave it blank if its no count.
In my report in the control source of CountofFINDG_RSK_LVL i have the
following code
IIf([CountofFINDG_RSK_LVL]=0,"",[CountofFINDG_RSK_LVL]).
Its printing "Error" on the report under that field.

Can someone help me please.

Moe

 

[John Spencer]

Change the control name to TxtCountofFINDG_RSK_LVL. Access gets confused
when you have an expression in a control that could refer to the control or
the field.

You could also use the format property of the control and not use the
expression at all.

Control Source: CountofFINDG_RSK_LVL
Format: 0;-0;"";""

 

[FA]

Thanks the format worked for me.

Moe