Posted on 2004-11-09
Last Modified: 2010-04-27
How can I setup some form of validation to ensure that the user enters a string consisting of three characters A-z followed by three digits 0-9.

Thanks for the help.
Question by:RICHARDH
    LVL 19

    Accepted Solution

    In your field definition, on the validate tab, choose validate by calculation,
    and enter a calculation like this:

    Left(field,3) >="AAA"  and  Left(field,3) <="zzz"   and
       Right(field,3) >= "000" and Right(field,3) <= "999" and
       Length(field) = 6

    This checks to make sure the left three characters are all letters, and the
    right three characters are all numbers. It then checks to be sure the whole
    thing is exactly 6 characters (otherwise someone could enter ABCDE01234)

    There are other ways to do the same calculation, this is just the easiest in
    my opinion.

    LVL 28

    Expert Comment

    and maybe use the custom msg to explain the required format.
    LVL 28

    Expert Comment

    LVL 19

    Expert Comment

    I certainly don't object...


    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
    Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    733 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

    24 Experts available now in Live!

    Get 1:1 Help Now