Results 1 to 4 of 4
  1. #1
    Join Date
    May 2007
    Posts
    37

    Unanswered: Unvisible field on a report

    In a report on a certain condition i want the field to be invisible
    and the code is :

    If Me.Field1 = 1 then
    Me.Field2.Visible = False
    End if

    But the problem is that when I type Me.Field2.
    the word Visible doesn't appear on the list.


    I use Access 2003.

  2. #2
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    I have the same beef. However, I do it all the time, and it works, event hough it doesn't pop up.

    Try it. Good luck,

    SL

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    check you are referring to the control and not the column in the data
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    May 2007
    Posts
    37
    Thanks a lot.

    I've tried without a condition and found that the visible=false worked.

    Than I made a condition that if the value is Null than visible=false ELSE visible=True.

    Great stuff

Posting Permissions

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