Changing from upper case to mixed case (Access 2000 SP3)

Topic

New Reply

This one should be simple enough but… How do I change text in a field from all upper case to mixed (proper) case?

Reply | Quote

Replies

In a query use :
StrConv(YourField,3)

Reply | Quote

Thanks for the code; worked perfectly. Where would you find a listing of all these codes?

Reply | Quote

In the help file or in a good book on access.
If you do a search on book, you’ll find a lot of posts with titles.

Reply | Quote

In the help file or in a good book on access.
If you do a search on book, you’ll find a lot of posts with titles.

Reply | Quote

Thanks for the code; worked perfectly. Where would you find a listing of all these codes?

Reply | Quote

Does this work in a text box as well or might I ask what does do the same in text box.

Reply | Quote

To use this in for a textbox, you should use this code in the afterupdate of the textbox:

Private Sub MyTextbox_AfterUpdate()
Me.Textbox = StrConv(Me.Textbox, vbProperCase)
End Sub

Reply | Quote

To use this in for a textbox, you should use this code in the afterupdate of the textbox:

Private Sub MyTextbox_AfterUpdate()
Me.Textbox = StrConv(Me.Textbox, vbProperCase)
End Sub

Reply | Quote

Does this work in a text box as well or might I ask what does do the same in text box.

Reply | Quote

In a query use :
StrConv(YourField,3)

Reply | Quote