Hello, I'm a new starter with Access VBA :o
Can anyone let me know how to get vbProperCase to capitalise not just the first letter of each name but the third and forth letter of surnames beginning with Mc or Mac respectively as well? I also want to capitalise the first letter of each name in a...