Make a combobox like a textbox

Posted on 2012-08-15
Last Modified: 2012-08-30
Is there a way to make a combobox look like a textbox.  Basically I have an ID that I need the DataSource propoerty but then want to display it as a textbox so they can't click a down arrow.
Question by:sharpapproach
    LVL 75

    Accepted Solution

    Set the Locked Property to Yes.  That way, they cannot select anything, but you can display as you like.

    LVL 61

    Expert Comment

    Have you tried Locked = true / enabled = false in your combo properties?

    An alternative if you don't want the arrow visible at all is to use a listbox and size it down to a single row of data.
    LVL 13

    Expert Comment

    Or use a textbox and query your result, which can be stored in a disconnected recordset.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    737 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

    18 Experts available now in Live!

    Get 1:1 Help Now