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

Force 4 digits in field

P: n/a
Hello folks,

Is there a way to always have a field populated with 4 digits even if
three digits may sometimes be entered into it? I am using a table in
which I import files that have 3 or 4 digits for the field value. But I
would like all the 3 digit numbers to automatically get a leading "0",
such as if 356 is entered, it should automatically get saved as 0356.

Any clues would be great help.

Thanks to all.
Kevin

Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Thanks for replying.

Tried it but did not work. Any idea why?

Nov 13 '05 #2

P: n/a
<ke*******@hotmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
Thanks for replying.

Tried it but did not work. Any idea why?

It worked for me. What's the field's data type? Did you get any errors?
Nov 13 '05 #3

P: n/a
<ke*******@hotmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
Thanks for replying.

Tried it but did not work. Any idea why?

If the data type is "Text", change it to "Number".

Keith.
Nov 13 '05 #4

P: n/a
It was Text and I changed it to Number and... it worked!!

Thank you for replying and solving my problem. Truly appreciate your
time.

Have a wonderful day!

Kevin

Nov 13 '05 #5

P: n/a
<ke*******@hotmail.com> wrote in message
news:11*********************@g43g2000cwa.googlegro ups.com...
It was Text and I changed it to Number and... it worked!!

Thank you for replying and solving my problem. Truly appreciate your
time.
Pleasure, glad I could help.

Have a wonderful day!

You too :o)
Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.