<div>
It does help in performance, see also this thread:<br />
<a href="http://office.microsoft.com/en-us/access-help/improve-performance-of-an-access-database-HP005187453.aspx" rel="ugc">http://office.microsoft.co<wbr />m/en-us/ac<wbr />cess-help/<wbr />improve-pe<wbr />rformance-<wbr />of-an-acce<wbr />ss-databas<wbr />e-HP005187<wbr />453.aspx</a><br />
<br />
HTH,<br />
Daniel
</div>


It does help in performance, see also this thread:
http://office.microsoft.com/en-us/access-help/improve-performance-of-an-access-database-HP005187453.aspx [http://office.microsoft.com/en-us/access-help/improve-performance-of-an-access-database-HP005187453.aspx]

HTH,
Daniel

<div>
But I guess the question is, in your experience, how much?
</div>


But I guess the question is, in your experience, how much?

<div>
Thanks - exactly what I was looking for
</div>


<div>
<div class="content wysiwyg-content">
Basic but very important question - how much should I be concerned with optimizing field size - for example, we have a table of vendors, maybe 1000 records, will grow to 2 or 3 times this size, but we have kept all the text fields at 255 characters - most of them are address, phone, other fields that probably can do with anywhere from 10 to 50 or slightly more characters.<br />
<br />
If is worth going in and shortening field lengths?<br />
<br />
Many thanks,<br />
<br />
Robert
</div>
</div>


Basic but very important question - how much should I be concerned with optimizing field size - for example, we have a table of vendors, maybe 1000 records, will grow to 2 or 3 times this size, but we have kept all the text fields at 255 characters - most of them are address, phone, other fields that probably can do with anywhere from 10 to 50 or slightly more characters.

If is worth going in and shortening field lengths?

Many thanks,

Robert

Field length - how much does it matter?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.