Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Feb 2004
    Location
    Jacksonville, Florida
    Posts
    70
    Thanks
    0
    Thanked 0 Times in 0 Posts

    changing list box to drop down list box (2000)

    How do I switch my list box over to a drop down list box? When I'm in design view of my form, I right click on the list box and choose "Change to." Though, I don't even see the drop down list box option....

    The items I want on the drop down menu are ones that I've manually typed in the list box, I don't have them listed on the main table? should I have to list them in the table first, or can I manually type in the list to chose from, then be able to change it to a drop down list box?

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

    Re: changing list box to drop down list box (2000)

    If you right click a list box while the form is in design view, and select Change To, two options should be enabled: Text Box and Combo Box. The latter is the name Access uses for a dropdown list. It shouldn't matter whether the row source of the list box is a table/query or a list of values typed in manually.

  3. #3
    Star Lounger
    Join Date
    Feb 2004
    Location
    Jacksonville, Florida
    Posts
    70
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: changing list box to drop down list box (2000)

    Thank you very much! I didn't realize a combo box was the drop down box. Again, thank you!

Posting Permissions

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