How text is displayed in entry fields and table data

  • Thread starter Thread starter Lenny
  • Start date Start date
L

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.
 
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
 
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
 
Back
Top