A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How text is displayed in entry fields and table data



 
 
Thread Tools Display Modes
  #1  
Old August 25th, 2009, 11:39 PM posted to microsoft.public.access.gettingstarted
Lenny
external usenet poster
 
Posts: 112
Default 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  
Old August 25th, 2009, 11:45 PM posted to microsoft.public.access.gettingstarted
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default 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  
Old August 26th, 2009, 12:24 AM posted to microsoft.public.access.gettingstarted
Mike Revis[_3_]
external usenet poster
 
Posts: 31
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:04 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.