Amend names to Proper Case eg MacX, O'x

[PaulJK]

Hello,

I have a Forename and Surname fields on a form and our company has asked to have any names entered amended to Proper Case.

I have searched this forum and found solutions using StrConv([Enter Your String],vbProperCase).

As many users indicate this will not work with hyphenated names such as Piggott-Smith, Irish names such as O'Hara and names with Mc or Mac in such as MacKenzie & McDonald.

I have not been able to find a solution whilst searching and would appreciate anyone suggesting any solutions which may have worked for them.

Thanks in advance.

 

[indesisiv]

try.
This


Steve