Validating multiple input maks on the same form

[GussyBoy]

I have a form where the user is required to input various accounts such as:
1) 116900 216113
2) 511210 2801
These accounts are only entered in these lengths. I want to be able to validate the account entered no matter which type of account is entered.
I've tried input masks 000000\ 0000CC, 000000\ 0000##, etc amoung others. Is my systax correct? Please help.
Thanks.

 

[lameid]

Assuming your field is text and you want to store the space, I think you want something like the following. Change the 0 to 1 if you do not want to store the space.

000000\ 000099;0;_

 

[GussyBoy]

thanks.....after I posted my problem, I came up with
000000 000099
I guess I was close. I'lltry it and let you know

 

[GussyBoy]

This worked great all I needed to do was add another 9 to accomodate 3 non-required digits. Question....what is the ';0;_' used for?

 

[lameid]

The 0 tells it to store the literals in the mask. In this case the space in the data. The default, 1 tells it to leave it out and just store the keyed text...

Data in table:
For 0: 116900 216113
For 1: 116900216113

Since it was an account number, I assmed it is a key soemwhere and the space is part of the key.

 

[GussyBoy]

Yes a space is there. Thanks for all your help.