Force 3 digit number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I force a number to be 3 digits? If someone enters a 1 can I have
Access store 001.
 
"001" is not a number -- it is text. Change you field to text and set the
format.
 
Ripper said:
How can I force a number to be 3 digits? If someone enters a 1 can I
have Access store 001.
Click to expand...

You can use a text field. Remember that 001 is not a number the number
is 1, You can display it as 001 or you can call it text and save it as 001
but then you can't add 001 + 001 and get 002 you would bet 001001 . :-)
 
Ripper said:
How can I force a number to be 3 digits? If someone enters a 1 can I have
Access store 001.
Click to expand...

look at formatting it as it's displayed, not when it's being stored
(assuming your data is always a number)
store
3
change the formating of the control showing it to 000
displays as
003
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making a variable number field into a fixed digit field 12
Set character specificiations for field in a table 2
Auto Number ID Field 4
Inserting default value in part of input mask 3
display a field in certain characters 4
Auto Generate Primary Field Value 5
LEADING ZEROS 7
Default the field - Search Fields As Formatted in Acess 2003 1

Back
Top