Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2003
    Location
    Belize City, Belize
    Posts
    5

    Unanswered: hiding fields on a report base on a condition

    I have an access report for which I want to hide two field based on a contion in a third field. Note I want these two to show for some records and not others.

  2. #2
    Join Date
    Nov 2003
    Posts
    7
    you could do it in VBA

    to make it simple, let's say it's just two controls. controlA will have the condition and controlB will be hidden or not hidden

    do an After Update event on controlA

    Private Sub ControlA_AfterUpdate()

    if ControlA = valueX then

    ControlB.visible = false

    end if

    end sub

  3. #3
    Join Date
    Sep 2003
    Location
    Belize City, Belize
    Posts
    5

    hide a field in a report

    I can't find the after update property for control on a report, please help

  4. #4
    Join Date
    Nov 2003
    Posts
    7
    oh, I misread your first post- I was thinking of a form, not a report.

    So on the report, do you want to hide the entire field, lable and everything, or do you just want the value to not show up?

    I don't work with reports much. I know it's possible, I'll see if I can figure it out

  5. #5
    Join Date
    Sep 2003
    Location
    Belize City, Belize
    Posts
    5

    hiding a field in a report

    the value not showing up

  6. #6
    Join Date
    Oct 2003
    Location
    Roanoke, Va
    Posts
    445

    Smile Re: hiding a field in a report

    Originally posted by zauny
    the value not showing up
    I'm not sure how flexible you need to be but I just set up a query to drive the report and in the query I determined what one field would display based on another using an IIf (Immediate If) statement.

    If your report is based on a table or query then this could work.

    Gregg

Posting Permissions

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