Can Continuous (sub)Forms be displayed horizontally in Access 2010?

[Joel_The_M]

Hello MS Access forums,

I have a subform which consists mostly of yes/no questions, so the questions are a fair bit wider than the answers. There may be more than one set of answers for each main record. (1: Many, Main:Sub), so I'd like to display the questions vertically and the records generate horizontal, ie a Tabular display with Columns and Rows transposed.

What I've found searching seems to say, "Nope," but they are all several years old at best, so maybe some things have changed since.

So can this be done w/ Access 2010?

Much Thanks,
JM

 

[tad0075]

It sounds like you have questions listed in 1 table and answers in another? You should be able to set the answers as their own subform within the main form, and you can format the subform however you like. Tabular layoutwill spread out the data horizontally, so that's probably what you want... main form set as Stacked layout, subform set as Tabular layout.

If you haven't done it before, there are a couple of ways to do this... easiest way is to set up the subform as its own form, then draw it into your main form. As long as it's in the Detail section and the data is linked correctly, it should work fine!

-Tyler

 

[Joel_The_M]

Thanks for your reply, Tyler,

Actually, the questions effectively make up the field names, and the answers the data. The number of questions are fixed, but may be answered more undetermined number of times, each time being a record. So that's easy to make a tabular subform to the mainform of the person answering info, but only as far as I can tell in the usual way, with the field/column names and answers running horrizontally, and the records running vertically.

Thanks,
Joel