Katrina has attended:
Access Introduction course
Access Intermediate course
Using Coding Proper Case (Title Case) on Forms
Hi, I want to use a code on my form so that after entering, it automatically goes from 'text' to 'Text'. What code would I use and where is it entered?
Thank you
RE: Using Coding Proper Case (Title Case) on Forms
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
