Capatilize a Table

  • Thread starter Thread starter Lonnie
  • Start date Start date
L

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
 
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
 
Back
Top