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 » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Text column widths overhead ???



 
 
Thread Tools Display Modes
  #1  
Old July 15th, 2004, 07:30 PM
Rapscallion
external usenet poster
 
Posts: n/a
Default Text column widths overhead ???

Does it really matter what width text columns are set to so long as the length is long enough. I've seen systems where every text column was set to lengths of 50, 100 or 255 even though the max data length was much shorter. Does doing this carry any overhead?
  #2  
Old July 16th, 2004, 07:15 AM
John Nurick
external usenet poster
 
Posts: n/a
Default Text column widths overhead ???

Answered in another group.


On Thu, 15 Jul 2004 11:30:04 -0700, "Rapscallion"
wrote:

Does it really matter what width text columns are set to so long as the length is long enough. I've seen systems where every text column was set to lengths of 50, 100 or 255 even though the max data length was much shorter. Does doing this carry any overhead?


--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding a coma to the text data in every row of a column Larry Worksheet Functions 1 June 26th, 2004 01:43 AM
Putting Mouse Over A Column No Longer Shows Additional Text Parrman General Discussion 0 June 10th, 2004 06:03 PM
Column widths joe Worksheet Functions 1 April 3rd, 2004 03:58 AM
column to text for multi-line text cells Manuela Worksheet Functions 3 November 18th, 2003 06:26 PM
Finding Text Value in Column Peo Sjoblom Worksheet Functions 4 November 14th, 2003 06:02 AM


All times are GMT +1. The time now is 02:59 AM.


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