Invisible Fields

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I have invisible fields on a unbound form that hold data. Does the size of
these fields matter as far as database size. The smaller the better? Do
they take less space and memory?
Thanks
DS
 
DS said:
I have invisible fields on a unbound form that hold data. Does the size of
these fields matter as far as database size. The smaller the better? Do
they take less space and memory?
Click to expand...


If by "fields" you mean a field in a table, then yes, data
takes up space. But Text/Memo fields only take up as much
space as the data stored in them so their size doesn't make
much difference.

If you are using the term "fields" casually when you really
mean controls, then no, it doesn't matter. Controls have a
fixed number of properties regardless of how large or small
they are when displayed, so their memory/space requirement
is always the same. OTOH, each control on a form requires a
relatively small amount of space, so a very large number of
them (up to the 754 limit) might have a measurable effect on
a very old, slow computer with a small amount of free disk
space or RAM.
 
Thanks Marshall,
I'm sorry they are unbound textboxes that may or may not have a value in
them....I just thought graphically a smaller one would take less than a
large field. It doesn't seem to matter unless you go crazy and fields
everywhere.
Thanks
DS
 
Back
Top