Access 97 has many codes you can enter into Table Design view that allow advanced formatting and layout of data already entered. This is how to convert the format of your data to all capitals: Select the table in the database task list, and click the Design button to the... More results like this http://www.msoffice-tutorial.com/i-have-lots-of-data-in-an-access-table-a-problem-i-have-is-that-all-data-is-in-capitals-and-i-need-to-change-all-the-first-and-last-names-to-proper-names-that-is-with-the-first-letter-being-capital.php Tags:namesaccessdesignfieldtableclickdatacapitalised0tellslettertypeenteredconvertlettersbuttoninputlistcodelscreeninsidemaskenterformatting