Just another validation question

[Gupta A.]

Hi everyone...I've got a GCSE project with databases which I need help with -
I'm declaring that so that anyone else in my school who sees this post
doesn't copy whatever reply I get...because, you know...that'd get us all
disqualified.

Anyway my question is - is it possible to validate a field so that its in
the "LLDD DLL" format...where "L" is a letter and "D" is a digit...the catch
is that the first four digits aren't necessary, but the last three are. Any
help would be great.

 

[tina]

depending on what you're doing, the easiest way might be to use an input
mask. take a look at the InputMask Property topic in Access Help for more
information. (that should be general enough for you and your classmates to
each get credit for figuring out the specifics on your own. <g>)

hth

 

[Tim Ferguson]

Anyway my question is - is it possible to validate a field so that its
in the "LLDD DLL" format...where "L" is a letter and "D" is a digit.

Remember that this will NOT catch large numbers of UK postcodes... for more
details see

http://www.answers.com/topic/postcode-1


hope that helps


Tim F

 

[Gupta A.]

Just...as a note... (not sure if you'll get this) Thanks...a lot. Helped a LOT.

 

[tina]

you're welcome

Just...as a note... (not sure if you'll get this) Thanks...a lot. Helped a LOT.