I normally do this sort of thing in the On Format Event for the section involved and just hide the control:
If Me.myControl.Value = 0 then Me.myControl.Visible = False Else Me.myControl.Visible = True End If The On Print event is often too late for doing control level formatting. Richard --- In [email protected], "owen_group_profile" <[EMAIL PROTECTED]> wrote: > Hi, > > you could try some code in the 'onprint' event of hte report which > would make the colour of the text the same colour as the background if > the value was '0'. > > Owen > > > > --- In [email protected], se e <[EMAIL PROTECTED]> wrote: > > Hi > > > > How to hide zeros from a report , the field is number field. In > excel we have something "ZeroValues", is it available in Access. > > > > > > --------------------------------- > > Sell on Yahoo! Auctions - No fees. Bid on great items. > > > > [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
