hide field on report based on value

[pdtit]

Hey,
I have the following question on a report to print out :

My report is in fact a ticket from a POS-system (6cm)

Is it possible to hide a field from my report if the value in this field is 0 ? (it is the price-field, format as Currency)

Regards,

Peter

 

[CosmoKramer]

In the On Format event of the section where Price appears, put logic like this:

If Me.Price = 0 Then
  Me.Price.Visible = False
Else
  Me.Price.Visible = True
End If

 

[pdtit]

Splendid.

I was thinking and thinking and thinking, but could't see the light anymore...

I never thought it was that simple.

Even by reading the code, I already knew it would work.

Thx a lot,

PdtIt