masking uk postcode access

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

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

Masking a uk postcode in access

resolvedResolved · Low Priority · Version 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:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.



Access provides an easy method of achieving a running total.



Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips


Server loaded in 0.09 secs.