Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jun 2003
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Disenable fields and Labels (Access XP)

    I think I'm missing something basic but if someone can humour me and sort this out I would appreciate it.

    On my front page I have various labels and fields, however some of the labels are not associated with the fields. I have written the VB so that on current all fields are disabled until you click on either an add or edit button which then enables them. When you disable the fields the formatting of the labels that are associated to the fields changes, however the formatting of the labels that are not associated does not. Can someone please let me know how I can either associate the labels to the appropriate field OR automatically change the formatting of the the labels so that they appear the same as those that are associated and are disabled.

    I would really appreciate any help on this.

    Thanks

    <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

  2. #2
    Lounger
    Join Date
    Jan 2003
    Location
    Herndon, Virginia, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disenable fields and Labels (Access XP)

    The way to associate a label with a field is to select the label, cut it (Ctrl-X), then select the field and hit paste (Ctrl-V). Access will usually put the label below the field, so you'll have to move it back to where it was originally, but it'll be associated with the field.

    Brent

  3. #3
    Star Lounger
    Join Date
    Jun 2003
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disenable fields and Labels (Access XP)

    That's great. However is there a way of associating labels when there are more than one label for a field. On my form I have a field that stipulates whether an item is leased or owned and if it's leased the next field is Lease Start Date and if it's owned it's Purchase Date, therefore 2 labels for one field, I tried this method and it didn't work do you please have any other suggestions?

    Many thanks.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Disenable fields and Labels (Access XP)

    I don't understand. are Purchase Date and Lease Start Date referring to different fields or are they just differing labels for the same field? If the latter, then the easiest way to handle it is by hiding one control and making the other visible, not by trying to associate the label with the control. However, if this is a continuous form, it isn't going to work. Give us the additional information, please.
    Charlotte

  5. #5
    Star Lounger
    Join Date
    Jun 2003
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disenable fields and Labels (Access XP)

    They are different labels for the same field, however I had hidden them and then made them visible but when the field was not enabled the label was not showing in the same formatting.

    I have since got round the problem by using the labelname.caption and then associating that label with the field.

    Many thanks for your help.

Posting Permissions

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