Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Burgas, Bulgaria
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    invisible control (Access 2000)

    I cannot make invisible the control in a continous form.
    For example, i want to make invisible the field "hall" and i use the following code:

    If IsNull(Me![hall) Then
    Me![hall].Visible = False
    End If


    What is wrong with my code?


    In each row of my form, i have three controls named room,hall ,attic and kitchen.In each row

    only one control has a value.
    For example, for project Number three the control that has the value is room, and the value is 4..Therefore the controls
    hall,kitchen and attic should be made invisible.
    The controls are placed onve over another in order to save place,and only this control will
    be visible that has a value.However, i cannot do it.
    May i ask for help ?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: invisible control (Access 2000)

    have you tried

    If IsNull(Me.hall) Then
    Me.hall.Visible = False
    End If
    Jerry

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: invisible control (Access 2000)

    The problem is that you are using a continuous form. In a continuous form there really is only one of these controls, so if you change its visible property it will apply to each record not just one.

    Where did you put the piece of code you posted? In which event? If youput it in the oncurrent event then it will execute when each record is the current one, but the change it makes will show up in every other record as well.
    Regards
    John



Posting Permissions

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