Using Coding Proper Case (Title Case) on Forms | Access forum

Hello Katrina,

Hope you enjoyed your Microsoft Access courses with Best STL.

Thank you for your question regarding converting lowercase text into Propercase in Access.

This can be done through the use of VBA code in modules which can then be applied to the After Update property of the text field in question.

It is recommended that you attend an Access VBA course which will help you with understanding how this could be done.

You can of course use an Update query to fix data using the StrConv function as follows:

StrConv([FieldName],3) which is placed in the Update To: row of the query.


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer