Return to Website

MS Access

Computers at Large brings MS Access Forum for you to ask questions, answer questions or look up solutions

MS Access
Start a New Topic 
Author
Comment
Access

I am creating a db with a drop down menu in every field. i have 167 fields in my table. after 151 it won't let me enter any more drop down fields. It gives me the error "Too Many Fields Defined". I don't know what to do. Any help would be appriciated.


Thanks


Kelby

Re: Access


You have reached the max. I would suggest that you look at the design again, I can not imagine why you need so many. If you really need that many, you could break them up on different forms. (Have a form for Demographic Info, then another form for some other major grouping, you can link them with a "next" button that opens the next form.

--- --- --- --- --- --- --- --- ---

Replying to:

I am creating a db with a drop down menu in every field. i have 167 fields in my table. after 151 it won't let me enter any more drop down fields. It gives me the error "Too Many Fields Defined". I don't know what to do. Any help would be appriciated.


Thanks


Kelby