First letter upper

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael Conroy - 08 Mar 2007 21:08 GMT

This is a rather trivial point but I was wondering if there was a way to
format an input make to capitalize the first letter and leave the rest
untouched. I know I could program something in afterupdate like
upper(left(textbox,1))&mid(textbox,2,99) but I just want to use the mask
here. If I use the upper case symbol >, I am assuming the lower case symbol
will turn the rest of the string to lowercase. Not what I want. If the user
wants some upper case later on that should be allowed. So if I wanted to
enter conroy, PhD, the result should be Conroy, PhD, not Conroy, phd.

Signature

Michael Conroy
Stamford, CT

Reply to this Message

fredg - 08 Mar 2007 21:43 GMT

> This is a rather trivial point but I was wondering if there was a way to
> format an input make to capitalize the first letter and leave the rest
[quoted text clipped - 4 lines]
> wants some upper case later on that should be allowed. So if I wanted to
> enter conroy, PhD, the result should be Conroy, PhD, not Conroy, phd.

If you wish to actually store the data this way, use code in the
control's AfterUpdate event:

Me![ControlName] = UCase(Left(Me![ControlName],1)) &
Mid(Me![ControlName],2)

No need to add the 99 in the Mid() function unless you do actually
wish to limit the characters to 99.
Mid([field],2) will return everything from position 2 on.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message