Validation rule

I would like a field in my table to have 5 characters. If
the entry have less than 5, a Zero adds to the front of
data.
If enter 345D. It should correct to 0345D.
If entry more than 5 characters, validate text pop-up.
Could someone help me with the "Zero adds to the front of
data"?

Thanks
Ashley

Well, if you're adding it through a macro, here is some sample code (should
work :-))

Dim A as string, B as string

A = "345D"
B = String("0", 5 - Len(A)) + A


B now contains the string you need :-) If it doesn't work...look up how to
use the String function.


Sincerely,
ASP.Confused


"Ashley" wrote in message
...
I would like a field in my table to have 5 characters. If
the entry have less than 5, a Zero adds to the front of
data.
If enter 345D. It should correct to 0345D.
If entry more than 5 characters, validate text pop-up.
Could someone help me with the "Zero adds to the front of
data"?

Thanks
Ashley

Stupid me....just realized what a "Validation Rule" is...lol. What I gave
you might help you out, but I'm stuck on this question too.


"ASP.Confused" anonymous@ wrote in message
...
Well, if you're adding it through a macro, here is some sample code
(should
work :-))

Dim A as string, B as string

A = "345D"
B = String("0", 5 - Len(A)) + A


B now contains the string you need :-) If it doesn't work...look up how
to
use the String function.


Sincerely,
ASP.Confused


"Ashley" wrote in message
...
I would like a field in my table to have 5 characters. If
the entry have less than 5, a Zero adds to the front of
data.
If enter 345D. It should correct to 0345D.
If entry more than 5 characters, validate text pop-up.
Could someone help me with the "Zero adds to the front of
data"?

Thanks
Ashley

try something like:

Me![MyField] = Right("00000" & [input],5)

I'm not certain of the placement of the quotes but it
should be similar to that.

Me![MyField] is where you want to store it
[input] is what the user typed in

HTH
-----Original Message-----
Stupid me....just realized what a "Validation Rule"
is...lol. What I gave
you might help you out, but I'm stuck on this question
too.


"ASP.Confused" anonymous@ wrote in message
...
Well, if you're adding it through a macro, here is some
sample code
(should
work :-))

Dim A as string, B as string

A = "345D"
B = String("0", 5 - Len(A)) + A


B now contains the string you need :-) If it doesn't
work...look up how
to
use the String function.


Sincerely,
ASP.Confused


"Ashley" wrote in
message
...
I would like a field in my table to have 5
characters. If
the entry have less than 5, a Zero adds to the front
of
data.
If enter 345D. It should correct to 0345D.
If entry more than 5 characters, validate text pop-up.
Could someone help me with the "Zero adds to the
front of
data"?

Thanks
Ashley




.

Ashley

Why? Are you more concerned about how it looks, or what character string is
stored? You can set the display format to zero-pad, without altering the
stored string.

--
Good luck

Jeff Boyce
Access MVP

Expanding on Ernie's method, here is this:

Me![MyField] = String$(5 - Len([input], "0") + [input]




"Ernie" wrote in message
...
try something like:

Me![MyField] = Right("00000" & [input],5)

I'm not certain of the placement of the quotes but it
should be similar to that.

Me![MyField] is where you want to store it
[input] is what the user typed in

HTH
-----Original Message-----
Stupid me....just realized what a "Validation Rule"
is...lol. What I gave
you might help you out, but I'm stuck on this question
too.


"ASP.Confused" anonymous@ wrote in message
...
Well, if you're adding it through a macro, here is some
sample code
(should
work :-))

Dim A as string, B as string

A = "345D"
B = String("0", 5 - Len(A)) + A


B now contains the string you need :-) If it doesn't
work...look up how
to
use the String function.


Sincerely,
ASP.Confused


"Ashley" wrote in
message
...
I would like a field in my table to have 5
characters. If
the entry have less than 5, a Zero adds to the front
of
data.
If enter 345D. It should correct to 0345D.
If entry more than 5 characters, validate text pop-up.
Could someone help me with the "Zero adds to the
front of
data"?

Thanks
Ashley




.