Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Input Mask to allow names such as O'Neal

Status
Not open for further replies.
Briscoe

Briscoe

Technical User
Feb 10, 2003
29
US
I have built a database (MS97) that has been in use for quite some time now. I realized that there was a problem with my input mask today when a user emailed me. The current input mask is to make sure the first letter of the name is capitalized so it is <L>??????????? I need to be able to allow names such as O'Neal, McClellan and possibly Schubel-Fries. Is there an input mask that will capitalize the first letter and allow for variations in the other characters?

Thank you in advance!
 
Status
Not open for further replies.

Similar threads

Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
924
dhookom
dhookom
PrimoSteve
  • Locked
  • Question
Cannot add Image to Command Button?
Replies
9
Views
332
PrimoSteve
PrimoSteve
renigar
  • Locked
  • Question
Trying to add hyperlinks to pdfs through form entry
Replies
0
Views
171
renigar
renigar
JanaLNelson
  • Locked
  • Question
Filter as you type combo box in Access 2
2 3
Replies
54
Views
761
JanaLNelson
JanaLNelson
MacroAlan
  • Locked
  • Question
Navigation Bar is too short to read
Replies
5
Views
214
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top