>Hey All,
>
>I have a table that I'm validating against...the fied I'm checking is called Pat_id. The format is 123-4567-89910. And the field is all character.
>
>How can I check to verify that the format of the id is 3, hyphen, 4, hyphen, 5.
>
>
>how can I create a class that handle that chcking

IF SUBSTR(pat_id,4,1) = '-' AND SUBSTR(pat_id,9,1) = '-'
It is good
ELSE
It is not good
ENDIF

You can put code in the valid event of the text box to handle the format checking