View Single Post
  #3  
Old February 9th, 2010, 03:23 PM posted to microsoft.public.access.tablesdbdesign
Jerry Whittle
external usenet poster
 
Posts: 4,732
Default Are rows stored in fixed or variable length records.

Variable. If you make a text field size of 255, but only put in 4 characters,
it only uses 4 characters of space.

However don't make everything 255 characters as the wizards look at that
value when creating text boxes on your forms and reports.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Dennis" wrote:

Hi,

This is just a point of curiosity for me. I realize that Access works the
Access works.

Does any one know if the rows are stored in the database as fix length
record or as variable length records?


--
Dennis