how to give first letter to be caps

[indhu]

hi all

suggest me, how to give first letter of my textfield to caps.

eg. if a person enters a name in the namefield. it should automatically turns to caps

[PEB]

Hi,

Possibly you use a form to enter information in your text field!

If this is the case in the text field properties choose event procedure and type the following code:

Me!TextField=Ucase(left(Me!TextField,1))+mid(Me!Te xtField,2, len(Me!TextField)-1)

You need only to change TextField with the name of yourrespective field name

Copy/Paste it from the name of the procedure that should be:

Sub TextField_AfterUpdate()

[NeoPa]

Assuming your TextBox is named 'namefield' then try :-

Private Sub namefield_AfterUpdate()
    namefield = UCase(Left(namefield, 1)) & LCase(Mid(namefield, 2))
End Sub

Excel has a function Proper() which does this but for all words in string, but it's not in Access library.

[Tanis]

Actually, Access does have a proper function, although it is a cconstant.

Private Sub tbName_AfterUpdate()
'Routine is run after tbName text box is updated.

On Error GoTo Err_tbName_AfterUpdate

tbName = Trim(tbName) 'remove preceeding spaces
tbName = StrConv(tbName, vbProperCase) 'convert to proper case


Exit_tbName_AfterUpdate:
Exit Sub

Err_tbName_AfterUpdate:
MsgBox Err.Number & " - " & Err.Description
Resume Exit_tbName_AfterUpdate

End Sub

[NeoPa]

As Tanis says, use the StrConv() function.
That's a better solution.

NB This will do it for each 'word' in the string rather than just the very first char. I suspect that's what you're after.

[missinglinq]

This comes up from time to time, and is always a sticky situation when working with proper names, because everyone is not named John Smith! Tanis' solution won't work, for example, with john smith iii or john macsmith or john smith-bradley! It'll yield John Smith Iii, John Macsmith and John Smith-bradley. Here is a link I had squirrelled away from a very good site that addresses these problems:

http://www.mvps.org/access/strings/str0008.htm

As Tanis says, use the StrConv() function.
That's a better solution.

NB This will do it for each 'word' in the string rather than just the very first char. I suspect that's what you're after.

[MMcCarthy]

This comes up from time to time, and is always a sticky situation when working with proper names, because everyone is not named John Smith! Tanis' solution won't work, for example, with john smith iii or john macsmith or john smith-bradley! It'll yield John Smith Iii, John Macsmith and John Smith-bradley. Here is a link I had squirrelled away from a very good site that addresses these problems:

http://www.mvps.org/access/strings/str0008.htm

Thanks Missinglinq

That's a nice link and going on my favourites list along with some other good mvp sites.

Mary

[indhu]

hi,

thanks for everyone yeah. in inputmask i used >L<gfsdjdkf.
it works fine. any way i 'll use this in coding