Input Mask in Access 97

[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

[fredg]

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.

[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.