Continuous Form in Columnar View

[yeatmanj]

Is there a way to display records on a continuous form in columns that wouldn't take me a week to program? Thanks in advance.

 

[Rich]

Use the Form wizard

 

[yeatmanj]

That's not what I mean. A "Continuous Form" (a form that displays all records like a datasheet) with the data displayed in columns instead of rows.

 

[pcs]

yeatmanj,

---you wrote----
That's not what I mean. A "Continuous Form" (a form that displays all records like a datasheet) with the data displayed in columns instead of rows.
----------------

if you mean in multiple columns, like record 1 in column 1, record 2 in column 2, etc. you better allow yourself more than a week.

otherwise do as rich suggests and use the form wizard. after you create the form, go back to design view, and change the form's default view to Continuous Forms.


hth,
al

 

[yeatmanj]

Alright then. How do I make a continuous form that displays the data in columns (Record1 in column 1, record2 in column2, etc)?

 

[Rich]

Crosstab?

 

[yeatmanj]

Sorry, I'm looking into that now. I was thinking Pivot for some reason.

 

[yeatmanj]

Cross tab won't work. It wants to report a data calculation and is really like a pivot table in that regard. I just want to change the continuous form view from a row type display to a column type display. If anyone knows a way to do this it would be greately appreciated.