Creating a multiple item form in Access 2013 only brings over the first 15 rows (fields) of the table
In Access 2013, I have a table with 18 fields.  When I use the form tool called multiple item, it creates the form but only brings over the first 15 fields.  The remaining fields are truncated.  I thought there may be something about the design of the table so I created a table with 27 fields (one 1 simple record/row).  But again, when I use the Multiple Item Form tool, only the 1st 15 fields appear in the form.  Is there a setting in Access that sets this limit?   I haven't been able to find one, nor have I been able to search the internet for information on this setting.  I can add additional fields after creation (a real pain), and other form design tools, including split form, don't have this issue. Hopefully someone here knows what's causing this
August 1st, 2015 2:59pm

I'm afraid it is a limitation of the multiple items wizard. You'll have to add additional fields manually in design view.
Free Windows Admin Tool Kit Click here and download it now
August 1st, 2015 5:47pm

Your answer appears to be correct, but it is odd that the other wizards produce complete results no matter how many fields are in the table.  You would think that Microsoft would list this limitation along with the many other limitations that are spelled out such as string size limits, etc.  I don't see any references to the multiple items field limitation anywhere is Access help.  Thanks for your response though.
August 7th, 2015 10:51am

If I got a dollar for every weird decision made by the Office developers, I'd be rich by now... ;-)
Free Windows Admin Tool Kit Click here and download it now
August 7th, 2015 11:26am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics