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

Posted on 2011-04-26
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
    LVL 48

    Accepted Solution

    go to Property then Data tab, set the "Limit to List" to Yes.
    LVL 6

    Assisted Solution

    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:
    LVL 48

    Expert Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
    Read about achieving the basic levels of HRIS security in the workplace.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now