Max Num of Fields

[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

 

[Rick B]

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

 

[John Vinson]

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?

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]