Subform: how do I arrange columns in columns, not rows?

[Rachel Garrett]

I am using Access 2003. When I create a new form with the query
wizard, I am given the option to create it in a tabular, columnar,
datasheet, PivotTable, or PivotChart view. If I have one-to-many
joins, there is the option to view it by subform.

Here is my problem. I have a subform where I really need to display
the data in columns, not in rows. But I cannot find a way to get the
"columnar" view in my subform. I only get the option to create the
subform in datasheet, tabular, PivotTable, or PivotChart view.

On a related note, is there a way to change the view *after* you've
finished the wizard?

Thanks,
Rachel Garrett

 

[Jeff Boyce]

Rachel

I may not be understanding your issue...

Have you tried opening a form in design view and changing the property
governing which view is displayed?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/