Text fields are variable, i.e. disk storage used in any given record depends
on the number of characters actually present in the field, not the maximum
number of characters defined for the field.

Numeric fields (long, integer, byte, currency, single, float) are fixed
width (the number of bytes for the type.)

The Attributes property of the Field in the TableDef will tell you if it's
variable width or not, e.g.:
? (Currentdb.TableDefs("MyTable").Fields("MyField"). Attributes AND
dbVariableField)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Dennis" wrote in message
...
Hi,

This is just for my own education and curiosity. Does anyone know if
Access
stores it's data records in a fixed length or variable length records /
rows?

I realize that the answer is some what immaterial as it works the way it
does, but as I said I would like to know for my own knowledge.

--
Dennis