Hi Ron,
Run an Update query that includes the UCase function. Start by creating a
normal Select query that returns the appropriate records. Then convert the
query to an Update query. In the Update To row, enter: UCase([FieldName]),
where fieldname is the name of your field. Run the Update query.
Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
