force entry of certain characters in text field? (1 Viewer)

[tenchy]

Hi,

I have a DB where I want text entry of the primary key to adhere to a certain format.
I'm already using a mask of >LL000000 to force two capital letter and 6 numbers.
Is there any way I can force extra restrictions, by making for example the first 3 characters to have to be AB1, thus making every entry follow format:
AB1<number><number><number><number><number>

(FYI: Access 2003)

 

[tenchy]

apologies for answering my own thread, and not finding the answer before I posted.
I can confirm that the sticky suggesting use google rather than on-site search is worth taking notice of!

With google I found this thread which has sorted me out.

http://www.access-programmers.co.uk/forums/showthread.php?p=567069