Re: Leading with 0's in a table.
- From: "Jeff Boyce" <nonsense@xxxxxxxxxxxx>
- Date: Fri, 2 Oct 2009 13:21:29 -0700
Debra Ann
Let's make sure we're talking about the same thing, first.
Numbers are things you add/subtract/multiply/divide. Any zeros that come at
the beginning are meaningless (that is, "000004236" = "4236").
If you'll be "doing math", then you have numbers. You can change the format
to change how they appear.
But if this is actually more of a "code", and "doing math" is not needed,
then change it to a text field. While you still will have the option of
entering "4236" and displaying "000004236" (via formatting), you could also
rig your form to convert anything less than nine characters to be
zero-padded when stored. (NOTE: you ARE working with your users via a
form, right?!)
It's a bit tough offering appropriate suggestions until we have a clearer
picture of what you are working with...
Regards
Jeff Boyce
Microsoft Access MVP
"Debra Ann" <DebraAnn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D9E38196-FEC7-4F0B-8CA0-3DF23DCF7107@xxxxxxxxxxxxxxxx
MS Access 2003:
I have a number field in a table that must be nine characters and fill
with
0's in the front of the number depending on how big it is. How do I mask
it
so that if the person types 4236 then it shows up as 000004236?
Thanks
.
- Follow-Ups:
- Re: Leading with 0's in a table.
- From: Debra Ann
- Re: Leading with 0's in a table.
- References:
- Leading with 0's in a table.
- From: Debra Ann
- Leading with 0's in a table.
- Prev by Date: Leading with 0's in a table.
- Next by Date: Re: Leading with 0's in a table.
- Previous by thread: Leading with 0's in a table.
- Next by thread: Re: Leading with 0's in a table.
- Index(es):
Relevant Pages
|
