By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,472 Members | 1,158 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,472 IT Pros & Developers. It's quick & easy.

Input mask property and Mac, Mc and hyphenated names

P: n/a
MS
The simplest input mask for peoples names is....
L<??????????????


But what about when you have names like MacDonald, or Mary-Anne?

Anyone come up with a good "all round" "idiots" mask that still applies
capitals and lower case when required - even for Mac and hyphens?
Nov 13 '05 #1
Share this Question
Share on Google+
11 Replies


P: n/a
On Mon, 21 Feb 2005 05:17:20 GMT, MS <Em***@Myemail.com> wrote:
The simplest input mask for peoples names is....
L<??????????????


But what about when you have names like MacDonald, or Mary-Anne?

Anyone come up with a good "all round" "idiots" mask that still applies
capitals and lower case when required - even for Mac and hyphens?


No such thing. Names are too varied for a simple mask to capitalize
correctly. Search this newsgroup for a thread on surnames about a month
ago.
Darryl Kerkeslager
Nov 13 '05 #2

P: n/a
MS

"Darryl Kerkeslager" <ke*********@comcast.net> wrote in message
news:op**************@tigger.cnorth01.va.comcast.n et...
On Mon, 21 Feb 2005 05:17:20 GMT, MS <Em***@Myemail.com> wrote:
The simplest input mask for peoples names is....
L<??????????????


But what about when you have names like MacDonald, or Mary-Anne?

Anyone come up with a good "all round" "idiots" mask that still applies
capitals and lower case when required - even for Mac and hyphens?


No such thing. Names are too varied for a simple mask to capitalize
correctly. Search this newsgroup for a thread on surnames about a month
ago.
Darryl Kerkeslager


Would it be feasible to code something for example with the OnChange event
where the mask is changed when the "-" key is pressed? Or if "Mac" is keyed
in, the mask changes to force the next character to be a capital?

Or would this get too messy and be asking for trouble?
Nov 13 '05 #3

P: n/a
On Mon, 21 Feb 2005 21:50:19 GMT, MS <Em***@Myemail.com> wrote:

"Darryl Kerkeslager" <ke*********@comcast.net> wrote in message
news:op**************@tigger.cnorth01.va.comcast.n et...
On Mon, 21 Feb 2005 05:17:20 GMT, MS <Em***@Myemail.com> wrote:
The simplest input mask for peoples names is....

L<??????????????

But what about when you have names like MacDonald, or Mary-Anne?

Anyone come up with a good "all round" "idiots" mask that still applies
capitals and lower case when required - even for Mac and hyphens?


No such thing. Names are too varied for a simple mask to capitalize
correctly. Search this newsgroup for a thread on surnames about a month
ago.
Darryl Kerkeslager


Would it be feasible to code something for example with the OnChange
event
where the mask is changed when the "-" key is pressed? Or if "Mac" is
keyed
in, the mask changes to force the next character to be a capital?

Or would this get too messy and be asking for trouble?


I think if you read the discussion I referenced, you'll see exapmples of
names far too complex for a mask - the O'Conners, van Siphouts, Van
Nostrands, McDonalds, MacTavishes, D'Altons, etc. *If* I were to attempt
this at all, I would do it strictly in code.
Darryl Kerkeslager
Nov 13 '05 #4

P: n/a
MS

"Darryl Kerkeslager" <ke*********@comcast.net> wrote in message
news:op**************@tigger.cnorth01.va.comcast.n et...
On Mon, 21 Feb 2005 05:17:20 GMT, MS <Em***@Myemail.com> wrote:
The simplest input mask for peoples names is....
L<??????????????


But what about when you have names like MacDonald, or Mary-Anne?

Anyone come up with a good "all round" "idiots" mask that still applies
capitals and lower case when required - even for Mac and hyphens?


No such thing. Names are too varied for a simple mask to capitalize
correctly. Search this newsgroup for a thread on surnames about a month
ago.
Darryl Kerkeslager


Would it be feasible to code something for example with the OnChange event
where the mask is changed when the "-" key is pressed? Or if "Mac" is keyed
in, the mask changes to force the next character to be a capital?

Or would this get too messy and be asking for trouble?
Nov 13 '05 #5

P: n/a
> Anyone come up with a good "all round" "idiots" mask that still
applies capitals and lower case when required - even for Mac
and hyphens?


Personally, I hate input masks with a passion. They don't actually help
me enter more accurate information - all they do is make it hard to
correct mistyping (I end up having to backspace all the way back to the
error, then retype everything). If I have to use a form, I much prefer
validation to happen after I finish with the field, i.e. in the
BeforeUpdate event.

That said, even in code it isn't simple to make sure a name is
capitalized properly -- as Darryl noted, it's not just "Mac" and
hyphens that can present problems. But you'll have less of a chance of
pissing off your users if you do your validation in code.

--

Just my two cents,

Martha Palotay
(don't google to email)

Nov 13 '05 #6

P: n/a
On Mon, 21 Feb 2005 21:50:19 GMT, MS <Em***@Myemail.com> wrote:

"Darryl Kerkeslager" <ke*********@comcast.net> wrote in message
news:op**************@tigger.cnorth01.va.comcast.n et...
On Mon, 21 Feb 2005 05:17:20 GMT, MS <Em***@Myemail.com> wrote:
The simplest input mask for peoples names is....

L<??????????????

But what about when you have names like MacDonald, or Mary-Anne?

Anyone come up with a good "all round" "idiots" mask that still applies
capitals and lower case when required - even for Mac and hyphens?


No such thing. Names are too varied for a simple mask to capitalize
correctly. Search this newsgroup for a thread on surnames about a month
ago.
Darryl Kerkeslager


Would it be feasible to code something for example with the OnChange
event
where the mask is changed when the "-" key is pressed? Or if "Mac" is
keyed
in, the mask changes to force the next character to be a capital?

Or would this get too messy and be asking for trouble?


I think if you read the discussion I referenced, you'll see exapmples of
names far too complex for a mask - the O'Conners, van Siphouts, Van
Nostrands, McDonalds, MacTavishes, D'Altons, etc. *If* I were to attempt
this at all, I would do it strictly in code.
Darryl Kerkeslager
Nov 13 '05 #7

P: n/a
mp************@yahoo.com wrote:
Personally, I hate input masks with a passion.


Agreed.

And I wouldn't even bother to try to validate names. Oh and in Indonesia it is quite
common to have only one name.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #8

P: n/a
MS

<mp************@yahoo.com> wrote in message
news:11*********************@c13g2000cwb.googlegro ups.com...
Anyone come up with a good "all round" "idiots" mask that still
applies capitals and lower case when required - even for Mac
and hyphens?


Personally, I hate input masks with a passion. They don't actually help
me enter more accurate information - all they do is make it hard to
correct mistyping (I end up having to backspace all the way back to the
error, then retype everything). If I have to use a form, I much prefer
validation to happen after I finish with the field, i.e. in the
BeforeUpdate event.

That said, even in code it isn't simple to make sure a name is
capitalized properly -- as Darryl noted, it's not just "Mac" and
hyphens that can present problems. But you'll have less of a chance of
pissing off your users if you do your validation in code.

--

Thanks - and to Darryl too.

Code it is!
Nov 13 '05 #9

P: n/a
> Anyone come up with a good "all round" "idiots" mask that still
applies capitals and lower case when required - even for Mac
and hyphens?


Personally, I hate input masks with a passion. They don't actually help
me enter more accurate information - all they do is make it hard to
correct mistyping (I end up having to backspace all the way back to the
error, then retype everything). If I have to use a form, I much prefer
validation to happen after I finish with the field, i.e. in the
BeforeUpdate event.

That said, even in code it isn't simple to make sure a name is
capitalized properly -- as Darryl noted, it's not just "Mac" and
hyphens that can present problems. But you'll have less of a chance of
pissing off your users if you do your validation in code.

--

Just my two cents,

Martha Palotay
(don't google to email)

Nov 13 '05 #10

P: n/a
mp************@yahoo.com wrote:
Personally, I hate input masks with a passion.


Agreed.

And I wouldn't even bother to try to validate names. Oh and in Indonesia it is quite
common to have only one name.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #11

P: n/a
MS

<mp************@yahoo.com> wrote in message
news:11*********************@c13g2000cwb.googlegro ups.com...
Anyone come up with a good "all round" "idiots" mask that still
applies capitals and lower case when required - even for Mac
and hyphens?


Personally, I hate input masks with a passion. They don't actually help
me enter more accurate information - all they do is make it hard to
correct mistyping (I end up having to backspace all the way back to the
error, then retype everything). If I have to use a form, I much prefer
validation to happen after I finish with the field, i.e. in the
BeforeUpdate event.

That said, even in code it isn't simple to make sure a name is
capitalized properly -- as Darryl noted, it's not just "Mac" and
hyphens that can present problems. But you'll have less of a chance of
pissing off your users if you do your validation in code.

--

Thanks - and to Darryl too.

Code it is!
Nov 13 '05 #12

This discussion thread is closed

Replies have been disabled for this discussion.