Table Design Field Question

[lm0304]

I need to change a field to be both numeric (####), yet be able to have alpha also (etc. AAA####).

I would be very appreciative to someone who had a quick answer!

Thanks

 

[jdegeorge]

You can set the field to TEXT and it's input mask to be

>AAA\-9999;;_

This assumes that you want 3 alpha characters to be first, it adds a dash inbetween, and then allows for 4 numeric characters.

I use this to enter account numbers.


Hope this helps.

Jim "Get it right the first time, that's the main thing..."