Names in input masks using apostrophies

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
You got that right!

Dave Macmurchie


Douglas J. Steele said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use of Input Masks 3
How do I use the letter 'L' in an input mask? 1
input mask - capitalize first letter? 7
Input mask for last name 5
Easy job, but no idea for correct input mask 6
upper case letters 4
Input Mask in tables 2
Input masks 1

Back
Top