Title Case formatting in tables

Topic

New Reply

I can format a field as uppercase. Can I format a field for Title Case, so that if I enter in lower case, one word or multiple word cities will capitalized correctly? (With my State field, capitalization shows when I proceed to the next field.) BTW, I prefer to enter data right from the table.

I’m not initially asking about macros…just as-I-go formatting.

Reply | Quote

Replies

The bottom line answer is no – you cannot set a field to be formatted Title Case in a table property. However with the Format function, you can do it on a form or in a query.

Reply | Quote

BTW, I prefer to enter data right from the table.

I’m not initially asking about macros…just as-I-go formatting.

In case you change your mind about both of these things, you can use the after update event of a control on a form to convert the text entered into title case.

For example:

Code:

me.StreetAddress = StrConv(me.StreetAddress, vbProperCase)

Reply | Quote

It is good practice to keep users from direct access to tables. For reasons like this one – ie lack of events to control the user’s input.

However in Access 2010 you will be able to use events in tables to run macros. There is an AfterUpdate which will run when a change is made to a field and a BeforeChange which runs when the user moves to a different record.

Reply | Quote