put a blank if the value is = 0

[mymy]

Hi all
I would like to put a blank where all value is = 0..is it possible? I read that yes, but It can cause some problem. How could I be able to don't have this problem?
Thankx in advance
Myriam

 

[Rich]

Assuming you mean not show the record on a report if the textbox value =0
Then in the on format event put:
If Me.YourTxtboxName=0 Then
Me.YourTxtboxName.Visible=False
Else
Me.YourTxtboxName.Visible=False
End If
HTH

 

[mymy]

thanks
I guess that It's what I need but now, I need a detail..what's the event on format? Because my access is in french. Could you tell me when is it? is it when the report opening?
THankX
Myriam

 

[Pat Hartman]

It is executed for each line in the report just before it is printed.