Results 1 to 4 of 4
  1. #1
    chaddresnick is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Dec 2014
    Location
    Dayton, Ohio
    Posts
    30

    Form Entry Question


    On a form, is it possible to have #### appear in the form box when it loads and then the user would type a 4 digit number in place of ####.

    Also, for the table associated with that form, how do I limit account numbers to a 4 digit numeric value?

  2. #2
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,933
    how do I limit account numbers to a 4 digit numeric value
    set the validation rule >999 and <=9999

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870

  4. #4
    chaddresnick is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Dec 2014
    Location
    Dayton, Ohio
    Posts
    30
    thank you for your help!

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

Similar Threads

  1. Replies: 5
    Last Post: 03-09-2014, 07:16 PM
  2. Question: Automated Data entry
    By tooold in forum Database Design
    Replies: 3
    Last Post: 08-18-2013, 11:53 PM
  3. Replies: 6
    Last Post: 09-27-2012, 08:27 AM
  4. Multiple data entry question
    By Appeal in forum Forms
    Replies: 3
    Last Post: 01-06-2012, 11:40 AM
  5. Redundant data entry question
    By mathonix in forum Forms
    Replies: 3
    Last Post: 01-29-2010, 08:54 AM

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