Yep, that will work in most cases. But if you use a Watermark or a background image, or you set the background colour of the section in code (to give you alternate bands for the Detail, for example) in which case .Visible is the only approach that will do the job.
And, yes, in the latter case you could control your "non-display" colour using the same code that you use for the background, but that's another aspect to maintain (and miss), going forward - which is a bad idea. Richard --- In [email protected], Jean-Pierre Filion <[EMAIL PROTECTED]> wrote: > Hi. > > How about conditional formating, if 0 then print white > > > elscrimmo <[EMAIL PROTECTED]> wrote: > 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 > > > Visit your group "AccessVBACentral" on the web. > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > --------------------------------- > > > > > --------------------------------- > Yahoo! Mail > Stay connected, organized, and protected. Take the tour > > [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/
