Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009

    Unanswered: Access 2007 Report Question

    I have a field on a report which i would like it to be not visible if the field is null. I would also want the fields label not to be visible if the field is null. How and where can I do this.

  2. #2
    Join Date
    May 2005
    Welcome to the forums

    I'd suggesting looking at the OnFormat event of the detail section (I think is the name of it off the top of my head), do something like:

    If Isnull(me.fldname) then
    me.fldname.visible = false
    me.lblname.visible = false
    me.fldname.visible = true
    me.lblname.visible = true
    end if

    (air code, obviously replace your control names in the appropriate spots)

    For a similar example of formatting a report on the OnFormat event, see here.
    Me.Geek = True

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts