If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
How text is displayed in entry fields and table data
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 "Lenny" wrote in message ... 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. |
#3
|
|||
|
|||
How text is displayed in entry fields and table data
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 "Jeff Boyce" wrote in message ... 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 "Lenny" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|