By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,700 Members | 1,513 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,700 IT Pros & Developers. It's quick & easy.

Input mask

P: n/a
I have imported a list of inmates from my jail. Their ID numbers are
a unique string. They all start with 0 (zero) and have 8 numbers.
Example: 00112333 or 01566887 or 05666888. Now that I have imported
them into Access, they show without the zeros. I have tried to tell
the imput mask to do 00000000 but nothing happens.

How do I get access to put enough zeros at the beginning of the string
to make 8 numbers?

Thanks,
M>
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Morpheseus wrote:
I have imported a list of inmates from my jail. Their ID numbers are
a unique string. They all start with 0 (zero) and have 8 numbers.
Example: 00112333 or 01566887 or 05666888. Now that I have imported
them into Access, they show without the zeros. I have tried to tell
the imput mask to do 00000000 but nothing happens.

How do I get access to put enough zeros at the beginning of the string
to make 8 numbers?

Thanks,
M>


Format(number,"00000000")

--
Error reading sig - A)bort R)etry I)nfluence with large hammer
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.