turn 2 digits into 7 digits.

  • Thread starter Thread starter New2Access
  • Start date Start date
N

New2Access

I have a table which a field outputs a text which is a number that
could contain 2 digits up to 9 digits.

i need to only see 7 digits, even if the field contains 2, i need it to
precede with zeros.

any ideas?
 

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

Shorten a 7 digit number in a text field 7
Field Digit Sum formula 6
Set character specificiations for field in a table 2
ValidationRule for 8 digits? 1
Add A Leading Zero 4
Combining two number fields into one 7
validation rule for exactly 5 digits, including leading zeros 0
how can i format a number field to display max 5 digits? 10

Back
Top