subform to display in columns rather than rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have multiple subforms in a bound form. I would like the data in one of the
subforms to display in columns rather than rows. Is this possible? Thanks.
Cathy
 
If you are asking, can I rotate the normal view for records by 90 degrees,
the answer is no.

Depending upon the data, you may be able to write a query that would provide
the records in that "rotated" format, but it may get very tricky if there
are a lot of fields in the query.

Alternatively, one could put a large number of textboxes on the form and
then use code to write values into them so that it appears to have been
rotated 90 degrees, but the design of this would be somewhat inefficient and
would be prone to constant editing.

Have you tried a crosstab query? It might do what you want for the results,
again depending upon the data.
 
Ken,
That answers my question. I probably will just change the layout of the
form. Thanks.
Cathy
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform Data Entry Setting 0
Subform Datasheet Total Row 3
Button in Subform 2
Excel Help to copy information from one row at a time to another sheet 1
"Highlighting" user's active subform selection 6
Parameter Value error in a Subform 0
How to display multiple records in one view in a subform 2
Subform displaying column titles 1

Back
Top