how do i switch the columns and rows in a form in datasheet view?

[Guest]

i am trying to create a sub-form with data that looks exactly like the paper
forms that i am entering it from. unfortunately, the paper form has all the
data vertically, whereas access puts the data horizontally -- i want to
switch the x and y axis. is there any easy way to do this?

 

[Larry Linson]

There's no convenient way to do what you want with forms. Once the data is
in your database, a Cross-Tab Query can retrieve it in that form (or a
Pivot Table View might be more appropriate, if you are using Access 2002 or
2003).

I wouldn't recommend you give users access to datasheet view -- there are
too many things they can do wrong. I suggest you use a continuous forms
view, instead, which looks much the same, but over which you have much
better control than over a datasheet.

Larry Linson
Microsoft Access MVP