Hi there

Just settitng up a db with schools information which will have field such as the following:

Contact Surname
Contact First Name
Post Code


I am hoping to set up validation rules or at least some 'checks' to ensure the data entered is in the correct format for things like postcode and was wondering if anyone could point me to any information on the subject since I'm sure this has been done many times before!

I foresee problems such as some london postcodes which do not follow the usual format and surnames such as McDougall where it is not just the first letter which should be capitalised

Any help would be gratefully received.


Also, is it still possible to 'register' as a premium user to dbforums as I thought it once was, I can't seem to find the advert anywhere.