postcode

[rob_jeffers]

I need to know how to be able to make my database accept only postcode format entries like RT24 6QP (english). Like a validation , it would only accept that format. How would i go about doing that.
Please explain to be in easy to understand contex as im no expert with access.

Thanks

 

[ColinEssex]

Have a look here

Col

 

[rob_jeffers]

not easy enough. You see, its for an exam im doing (its not cheating, during breaks i am alowed to do some research)
The exact question is
Post code enteries are consistent - 2 letters, 2 numbers, space, 1 number , 2 letters e.g RT34 4FD.
And as it is only a gcse exam i shouldnt be as complicating as that thread you just linked to. Thanks anyway

 

[Bat17]

Post code enteries are consistent - 2 letters, 2 numbers, space, 1 number , 2 letters e.g RT34 4FD.

Wrong, Post office has issued lots of odd codes that dont fit the pattern!

have a look at this post though
http://www.access-programmers.co.uk/forums/showthread.php?t=102556&highlight=postcode+validation

Peter

 

[ColinEssex]

You see, its for an exam im doing (its not cheating, during breaks i am alowed to do some research)
The exact question is . . . . . . .

Lets get this straight -
1) you know what the question is -

2) then you get a break for "research" -

3) so you look up the answer and

4) go back and get top marks?

Its no wonder kids these days never fail their exams

Col

 

[Juan]

Check this out - it works very well. It doesn't only accept the correct format, but also validates it so, for instance, it wouldn't accept XY34 1PG even though it's in the general format that is consistent with a UK postcode. There is no city with the abbreviation XY.

http://www.access-programmers.co.uk/forums/showthread.php?t=102663

 

[Kassy]

Post Code

Try AA00\ 0AA 'note the space' - I had same problem and was told postcodes are difficult because they are not all this format but it suited me because I only wanted the Post Code around my area which was nearly allways this format.