Text Format in Tables...

  • Thread starter Thread starter avw410
  • Start date Start date
A

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???
 
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).
 
Back
Top