How text is displayed in entry fields and table data

[Lenny]

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.

 

[Jeff Boyce]

Lenny

Access tables may look like spreadsheets but they aren't. Don't use the
tables directly.

Instead, create queries that return the records/fields you want to see, then
create forms based on those queries to display the values. You can format
the controls on the forms to display however you want.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Mike Revis]

Look at the format property of the table fields and the form controls. If
the symbol > is present it will cause the data to be displayed as all caps
regardless of how it was entered.
Mike