Capatilize a Table

[Lonnie]

I am trying to find out how to capitalize a table. The
table has ucase and lcase now I would like it to be all
Ucase and to see it as ucase in a reportor form without
altery those projects so I guess I am asking to run a job
or something that will change the case or a query to
remake the table???????? I have set code behind any forms
that now enter in caps only but I get some information
from the table constantly (New Banks and address)I pull
from the table because it updates automatically. Thanks
for any help

 

[Rick B]

Use an update query. Include each field you wish to change. In the "update
to:" box under each field, put the following...

=UCase([SomeFieldName])


Hope that helps,

Rick B