Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Sep 2006
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Visible labels (Access 2000)

    I have an option group for the months. Next to the controls i also have 12 labels called M1,Me etc and l1, L2 etc. On each of these labels is written the name of the month and some other words.I meet with difficulties in navigating between the months.For example if i choose january, then the control L1 and M1 should be visible, but if i chose February,then these controls must disappear regardless of the month chosen.Can you help me ?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Visible labels (Access 2000)

    Why would you want to make the names of months invisible? That makes it more difficult for the user to select a month.

  3. #3
    2 Star Lounger
    Join Date
    Sep 2006
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Visible labels (Access 2000)

    The names of the months stay visible on the option box. What i mean is the labels above the control where the result of the option box is shown. When i choose a month, the result appears on the control of the form. I want, above this control, to have a label for each montn. The label for january with name M1, shoulkd be made visible only when the option january is clicked.But when i clik on another month, the label for january should be made invisible. When i click on another month, only this label should be made visible. For me it is very difficult

    kind regards

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Visible labels (Access 2000)

    Instead of 12 labels, each with a different caption, you could use one label. You can change the caption of this label in the After Update event of the option group:

    Private Sub Monaten_AfterUpdate()
    Select Case Me.Monaten
    Case 1 ' January
    Me.LabelName.Caption = "This"
    Case 2 ' February
    Me.LabelName.Caption = "That"
    ...
    ...
    Case 12 ' December
    Me.LabelName.Caption = "Other"
    End Select
    End Sub

  5. #5
    2 Star Lounger
    Join Date
    Sep 2006
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Visible labels (Access 2000)

    What a good idea ! It saves so much time and efforts !

Posting Permissions

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