Max Num of Fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brad - 31 Mar 2005 23:37 GMT

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

Reply to this Message

Rick B - 31 Mar 2005 23:49 GMT

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.
>
[quoted text clipped - 6 lines]
>
> Brad

Reply to this Message

John Vinson - 01 Apr 2005 00:50 GMT

>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]

Reply to this Message