Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Posts
    1

    restricting combo box entry

    Hi all

    i have a combo box which staff use to select their name from the list. How to i stop people from typing their own values in the box. I only want them to be able to enter a value from the list provided not whatever they want.

    thanks in advance for your help

  2. #2
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    Location
    Chicagoland
    Posts
    109
    My two cents...

    I assume that your row source type is a Table/Query. For your combo box Properties in the 'Data' tab, the 'Limit to List' should be Yes.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Possibility of Auto-creating an entry
    By agrundvig in forum Access
    Replies: 0
    Last Post: 09-24-2008, 09:30 AM
  2. Replies: 0
    Last Post: 08-17-2008, 12:19 PM
  3. Restricting Results In Reports
    By Hawkx1 in forum Reports
    Replies: 0
    Last Post: 06-24-2008, 09:53 AM
  4. Date Stamp On Entry of Record
    By tscholts in forum Forms
    Replies: 3
    Last Post: 04-01-2008, 07:08 PM
  5. Replies: 0
    Last Post: 03-26-2008, 08:46 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums