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

Resolved · Low Priority · Version 2007

Thu 11 Apr 2013, 14:29 Delegate Katrina said...

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

Fri 12 Apr 2013, 12:40 Trainer Rodney said...

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

Fri 19 Apr 2013: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips