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

Input Mask in Access 97

P: n/a
Bob
I want to use an input mask to force the first letter of a field to be a
capital, then have the rest of the field be as entered. By using the > sign
before the first, then the < sign before the rest, I can almost accomplish
this. However, this forces all the rest of the entry to lower case so I can't
enter a name like McDonald. Any advice on how I can do this? Thanks.

Bob

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Thu, 20 May 2004 19:00:05 GMT, Bob wrote:
I want to use an input mask to force the first letter of a field to be a
capital, then have the rest of the field be as entered. By using the > sign
before the first, then the < sign before the rest, I can almost accomplish
this. However, this forces all the rest of the entry to lower case so I can't
enter a name like McDonald. Any advice on how I can do this? Thanks.

Bob

You are using a form for data entry, I hope.
Don't bother with a mask.
Let the user enter the name with or without the first letter
capitalized.
Code the Control's AfterUpdate event:
[ControlName] = UCase(Left([ControlName],1)) & Mid([ControlName],2)

mcDonald and McDonald becomes McDonald.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 12 '05 #2

P: n/a
Bob
In article <11****************************@40tude.net>,
fg******@example.invalid says...
Fred,
Thanks, your code works fine. I had to put it in a Macro because for some
reason it doesn't work in an expression for my unbound control. Thanks again.

Bob
You are using a form for data entry, I hope.
Don't bother with a mask.
Let the user enter the name with or without the first letter
capitalized.
Code the Control's AfterUpdate event:
[ControlName] = UCase(Left([ControlName],1)) & Mid([ControlName],2)

mcDonald and McDonald becomes McDonald.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.