Results 1 to 4 of 4
  1. #1
    Join Date
    May 2006
    Posts
    11

    Unanswered: disabling items in a combobox

    how can i disable items in a listbox?

    how can i do this in a button click event?
    that when i click the button some items in the combo box will be disabled/or cannot be clicked?
    if i have this items
    yellow
    red and blue
    how can i disable yellow alone?

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    If you're thinking of using the controls that are provided with Access then you're out of luck. You will need to find a third-party control to do this or create your own. Do a search for VBAccelerator Controls. They may have what you need.

    .
    Environment:
    Self Taught In ALL Environments.....And It Shows!


  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    As Cyberlynx says what you are trying to do isn't part of standard access functionality. The most effective way to do that is too only have the available choices int he combo / list box (invovles eoithjer a requery or alteration to the row source on each cnage

    another option is to use radio buttons (however these only work effectively if there are few choices (say no more than 10..20, preferably less)

    another option is to check on each clikc of the list / combo box whetehr that choice is valid for that item.
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    If you provide more details about what you are trying to do then I am sure someone will be able to give more help. If the choices are not valid then why would you want to display them?

Posting Permissions

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