Input Help

[Aurora]

I am working on MS Access 2003.
I have a field that I want to start with "PM--" and then allow the user to
add 6 numbers after that. I have forgotten how to set this up in my
Database. Can someone please help me?

Aurora

 

[John W. Vinson]

I am working on MS Access 2003.
I have a field that I want to start with "PM--" and then allow the user to
add 6 numbers after that. I have forgotten how to set this up in my
Database. Can someone please help me?

Aurora

If the field ALWAYS contains PM-- at its beginning, then you would do best not
to store it at all; you can *display* it by using a Format property like

"PM\-\-000000"

How do you want to handle fewer than six digits: prohibit entry? leading
zeros? trailing blanks?