Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2005

    Unanswered: Input value by Combox only


    In MS Access, the form,

    I make one combox, I want anybody input the value by dropdown list, they cannot input the value by typing in keyboard.

    How can I lock to enter the value by typing, but they can input it by dropdown list.

    Because, if I lock the field, then we never enter the value, if no lock, then we can enter it either dropdown list option or type in keyboard.

    I just want to make dropdown list option to enter the value.

    Please let me know, thanks.

  2. #2
    Join Date
    May 2005
    I'm having trouble understanding your problem, could you try to explain again a little more clearly?
    Me.Geek = True

  3. #3
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6
    I'm not sure you can stop the user from typing, but you can set the Limit To List property of the combo to Yes, so they can only type in values that exist in the list.

  4. #4
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    set the limit to list property = true, that way round you can only accept a value that is in the combos row source.

    ther alternative is to use a list box

Posting Permissions

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