Max Num of Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thanks for taking the time to read my question.

I have a form that I am viewing in datasheet view. I have 42 fields, but
not all show up.

Is there a max number of fields allowed on a form?

Thanks,

Brad
 
Go to help and type "specifications" then select form specification.

The limit is in the 200's I believe.

That is over the life of the form though. Adding and then deleting a
control still counts as one.

I think compacting the database resets the count.

Rick B
 
Thanks for taking the time to read my question.

I have a form that I am viewing in datasheet view. I have 42 fields, but
not all show up.

Is there a max number of fields allowed on a form?
Click to expand...

648 or some number in that range.

I suspect that some of the fields in your datasheet have been shrunk
down to zero width (one of the many reasons I don't use datasheets
much); or it may be that the Recordsource of your form is a query
which does not select all 42 fields in the table.

John W. Vinson[MVP]
 
Back
Top