Input Help

  • Thread starter Thread starter Aurora
  • Start date Start date
A

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
 
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
Click to expand...

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?
 
Back
Top