access.course - Creating drop down fields

Resolved · Low Priority · Version Standard

Thu 14 Dec 2006, 11:54 Delegate Emily said...

Emily has attended:
Access Introduction course

Creating drop down fields

Hi

I want to create drop down menus within the field eg in 'title' have 'Mr', 'Miss', 'Mrs', 'Ms' & 'Other' on the drop down. How would I do this?

Thanks

Thu 14 Dec 2006, 15:48 Trainer David said...

RE: Creating drop down fields

Hi Emily

I will assume that you are trying to do this from a Microsoft Access Table. What you need to do is go into design view, then select the field that you want and then click onn the lookup tab. Then where it says display control, select either list box or combo box. Once this is done, go back to the field that you are working with and in the column titled Data Type select lookup wizard from the drop down list, then select the option to type in your own values. Click next. Then type in you desired values. Click finish.

Hope this helps

David

Mon 14 Jan 2008, 15:14 Delegate James said...

RE: Creating drop down fields

This is my question exactly. But your answer starts with an assumption Emily means Access... I really wanted to know if this is possible in excel, to limit data entry to a list of options.

Thanks

Mon 21 Jan 2008, 15:59 Trainer Katie said...

RE: Creating drop down fields

Hi James,

You can also achieve this in Excel but you need a bit of VBA code.

1) To create a drop down list, you must first draw a COMBO BOX from the TOOLBOX toolbar.
2) Switch on Properties to name it, e.g. cboList1
3) Once it's drawn, double click inside the COMBO BOX picture (it will then switch on VBA window)
4) Put in the code starting with combo box name, for example: cbolist1.additem "Apple"

The .additem code will add labels into the box.

Let me know if this is sufficient. There is another way for a dynamic list of labels, using FOR...NEXT loop

Hope this helps.

Regards,

Katie