Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » access.course - Creating drop down fields
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
access.course - Creating drop down fields
Resolved · Low Priority · Version Standard
Reply
Creating drop down fields
HiI 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
For upcoming training course dates see: Pricing & availability
RE: Creating drop down fields
Hi EmilyI 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
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
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
|
 |
|
» Forum post: Access 2003 |
What are the advantages of moving to Access 2007?
