[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


How do I stop users free typing in combo box in Access 2007

Posted on 2011-04-26
Medium Priority
Last Modified: 2012-05-11

I am creating a form using Access 2007 with a combo box.  However I don't want users to be able to 'freetype' in the box and only be able to select from the list.

I have tried "limit to list" in properties, which just changes back to "no", and a few other things - but nothing seems to work?

Please help
Question by:heijmer
  • 2
LVL 54

Accepted Solution

Ryan Chong earned 1000 total points
ID: 35465592
go to Property then Data tab, set the "Limit to List" to Yes.

Assisted Solution

richardburwood earned 1000 total points
ID: 35465599
The combo box can be tricky to setup. The Limit to List option is the correct way to do this.

Take a look at the link below: http://www.fmsinc.com/free/NewTips/Access/ComboBox/AccessComboBox.asp
LVL 54

Expert Comment

by:Ryan Chong
ID: 35465602
and set "Allow Value List Edits" to No if you don't want new values to be added into list.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question