Check Text for Capitalization

[Brogrim]

I want the text in name fields to be inputted correctly, How do i ensure this happens, do i ghange the format properties on the form.

 

[TheAceMan1]

How are ya Brogrim . . . . .

Maybe [blue]StrConv(string, vbProperCase)[/blue] is what your looking for.

[blue]StrConv("bobby williams", vbProperCase)[/blue] returns:
[purple]Bobby Williams[/purple]

See Ya! . . . . . .

 

[Mute101]

Hi,

You can pass the text through the StrConv function to get what you require.

ie. in the after_update event.

Me.Text0 = StrConv(Me.Text0, vbProperCase)

Hope that helps.
Sim

----------------------------------------
I was once asked if I was ignorant or just apathetic. I said, "I don't know, and I don't care."
----------------------------------------