I am trying to make my parts order database output the form to an Excel
spreadsheet and retain the layout, when I export Excel just gives a
spreadsheet with each field in a column. There is one address and a list of
up to 52 parts in two columns

You can't export a form. You could export a report but the layout will not
be kept either. What i would do is export the result of a query to a hidden
sheet the the Excel workbook. Create another sheet with tel lyout rquired
and link to the cells of the hidden sheet.

"Mike DFR" wrote:

> I am trying to make my parts order database output the form to an Excel
> spreadsheet and retain the layout, when I export Excel just gives a
> spreadsheet with each field in a column. There is one address and a list of
> up to 52 parts in two columns

You can only print a form, save an image of it, or turn it into a report.
Exporting only exports data, not the form's definition. You can export the
definition of a form to a text file with code to:

Application.SaveAsText

and reload it back into a new form with:

Application.LoadFromText
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Mike DFR" <(E-Mail Removed)> wrote in message
news:91A9B669-26A3-4552-BF58-(E-Mail Removed)...
>I am trying to make my parts order database output the form to an Excel
> spreadsheet and retain the layout, when I export Excel just gives a
> spreadsheet with each field in a column. There is one address and a list
> of
> up to 52 parts in two columns