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!

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

Cap

Status
Not open for further replies.

Ielamrani

MIS
Jul 7, 2005
183
US
Hi,
Can someone help on how to make the first letter of a name capital.
Example: I enter in a text box james, I want the text box to show James.
Thanks
 
In the textbox Afterupdate event property put:

me.nameofthistextbox =
strconv(me.nameofthistextbox,vbPropercase)
 
Hi
You can use an Input Mask
>L<?????????
But this can be a nuisance for say, James Joseph, or you can convert in a Before Update event:
Me.txtText=StrConv(Me.txtText, vbProperCase)
 
Thank very much you guys. The code worked.
Remou, you're right before I tried this: >L<????????? and it did not work.
Ismail
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top