subform to display in columns rather than rows

C

csingram

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
 
K

Ken Snell [MVP]

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.
 
C

csingram

Ken,
That answers my question. I probably will just change the layout of the
form. Thanks.
Cathy
 
Top