Text Format in Tables...

[avw410]

I have a user that is always putting data into the tables with her caps lock
on. I have told her several times not to. Is there a way to format all the
text in a table to make it sentence case???

 

[Tim Johnson]

First, I am assuming that you aren't allowing a user to enter data directly
into tables. If you are, you might strongly want to consider using a form
for this instead. There are multiple advantages to using forms instead of
directly entering into tables, controlling casing is one of them.

Now; to alter the casing, you might try looking in the Access help file at
the StrConv function (it works in update queries, too, but needs the value
assigned as opposed to the Constant).

 

[Tim Johnson]

You may also want to check out this link for sentence casing code:

http://vbcity.com/forums/topic.asp?tid=17044

This could also work in vba with some slight modifications.