How do I convert all fields to CAPS?

[mcmcd99]

I have a database where many different people enter data. For the sake of consistency, I would like to convert all information in the table to CAPS. I would also like to ensure that all data entered hereforth is automatically converted to CAPS. Anyone have any suggestions please?

[June7]

I use VBA in AfterUpdate event of textbox or combobox. Example:

Private Sub tbxFieldPL_AfterUpdate()
Me.tbxFieldPL = UCase(Me.tbxFieldPL)
End Sub

You will have to run an UPDATE query on the existing records.

UPDATE tablename SET field1=UCase(field1), field2=UCase(field2);

Otherwise, just use formatting in forms and reports to show all caps without actually altering the data.

[mcmcd99]

Wonderful, thank you! I will try that here in a few minutes and let you know how it works.