How text is displayed in entry fields and table data

I have inherited an Access 2003 database. Some of the entry fields on the
entry forms display entries in ALL CAPS and others in Upper and Lower. When
clicking on a field that displays the entry in ALL CAPS, the text changes to
Upper and Lower but when viewed in table data, it appears ALL CAPS.

How can I change these entry fields to display as Upper and Lower
consistently and for the table data to display upper and lower as entered
thru the entry form? When I export the table data, I have to clean up all of
the entries that are coming thru in ALL CAPS.

Assistance is really appreciated.