Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007

    Validation Rule

    ok, Hello I'm new here - & I am having problems with 'validation' of some fields.

    I have a Table 'E.Customers' & my Primary key (S.ID) is a '15 digit number'.
    So, I have use 'Text' as Data Type.
    Field Size: 15 & I have use a 'Validation Rule': (Like "???????????????")

    My validation Rule is not completed since I also want to prevent 'letters'/'Unicode Characters'.
    if this is something possible to do - Can someone help me please ?

    If there exists some useful Guides on 'Expression Builder' in Access, a link would greatly help me. :?

  2. #2
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    Have you tried using a Social Security 'input mask'? It's one of the properties for a text field in a table.

  3. #3
    Join Date
    Oct 2007
    ok thx, the Social Security 'input mask' works fine..

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

Similar Threads

  1. Data Validation - Please help
    By larry S in forum Access
    Replies: 0
    Last Post: 11-16-2008, 10:24 PM
  2. Validation Rule: Date
    By krymer in forum Access
    Replies: 0
    Last Post: 08-27-2008, 03:30 PM
  3. Validation on import
    By andy_42 in forum Import/Export Data
    Replies: 1
    Last Post: 10-23-2006, 03:52 PM
  4. Validation rule for a text field
    By wasim_sono in forum Forms
    Replies: 4
    Last Post: 03-14-2006, 11:39 PM
  5. Field Level Date validation
    By fadone in forum Forms
    Replies: 1
    Last Post: 12-09-2005, 10:23 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