Names in input masks using apostrophies

[Guest]

Hi, I want to ad and input mask to a last name field that makes the first
character upper case and all the following letters lower case (which would
normally be something like >L<??????????????) but what do I do if the
person's name has an apostrophe in in (like O'Brien) and I want the first
letter after the apostrophe to be uppercase. Also how do I work it with
names that begin with Mac or Mc, where I want the first letter following the
'c' to be uppercase? Any ideas on how to work this?

 

[Douglas J. Steele]

The only way would be to write VBA code to do this. Note, though, that not
all Mac or Mc names follow the rule you're proposing.

 

[Dave]

You got that right!

Dave Macmurchie

The only way would be to write VBA code to do this. Note, though, that not
all Mac or Mc names follow the rule you're proposing.