Results 1 to 2 of 2
  1. #1
    jbedward is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    Dec 2009

    Formatting control boxes in a Form

    I've only been using Access for six weeks and have learned quite a bit. I just successfully created a form that will be used by about six people and I want to have one of the controls to have a validation rule. They will be entering a code number from a list of about 50 and I want to make sure that they can't make a keying error. I thought 50 options might be cumbersome in a combo box but I'm not sure. I don't know how to write the validation rule. I also want to format a different control box so that the keyer is required to fill in the box. How do I do that?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    8300' in the Colorado Rocky Mountains
    A ComboBox would be just fine for 50 choices. If AutoExpand is set to YES then it moves down the list as the user types. Your second question will probably involve checking for the entry in the BeforeUpdate event of the form.

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

Similar Threads

  1. Replies: 2
    Last Post: 11-25-2013, 10:56 AM
  2. Replies: 0
    Last Post: 12-08-2009, 01:19 PM
  3. Auto Formatting Text in a Form
    By swicklund in forum Access
    Replies: 0
    Last Post: 07-23-2009, 01:15 PM
  4. Combo boxes on a form
    By Maranna in forum Forms
    Replies: 1
    Last Post: 06-22-2009, 01:48 PM
  5. Linked control in form
    By Zipster1967 in forum Forms
    Replies: 0
    Last Post: 04-14-2007, 01:40 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
Other Forums: Microsoft Office Forums