Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

masking uk postcode access

Forum home » Delegate support and help forum » Microsoft Access Training and help » Masking a uk postcode in access

Masking a uk postcode in access

ResolvedVersion 2007

James has attended:
Access Intermediate course

Masking a uk postcode in access

Please could you advise what input mask I should use for a uk postcode?
Thanks,
James Gledhill

RE: masking a uk postcode in access

Dear James

Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.

Please refer to the following link as the answer to your query may sound simple but can be a bit complicated as all UK post codes do not follow the same pattern:

http://www.pcreview.co.uk/forums/thread-1680510.php


If you are not familiar with The coding side of the access you may want to attend one of our Access VBA course that would help you to be more confident in understanding the Code that is explained in the lin. For more information on the VBA Course please refer to the following link:

https://www.stl-training.co.uk/ms-access-training-courses-in-london-2003-vba.php


I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Access tip:

Display current date & time in column of any width

The worksheet function =NOW() returns the current date & time. When entered into a column which is not wide enough to display the value NOW returns, the cell displays ###

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.