How to hide a field only if its at a set value?

[Stevehewitt]

Hey,

I have a purchase order report that comes off. It has 10 rows allowing for a total of 10 purchaes on one order. If a user only purchases say 4 items, the fields on the reports still show a "0" figure for the fields that have a currency or number format. Is there anyway to stop the report from showing these fields unless they are above "0"?

Thanks,

Steve Hewitt

 

[mp9]

Let's say the field in question is called Text1 - find the relevant report section's OnFormat event and add the following line of code:

Text1.Visible = (Text1 > 0)

Hope this helps.

http://www22.brinkster.com/accessory/