How do you make a form look and feel like a spreadsheet?

[Bwanamkubwa]

Hello
I am trying to make a grade book ledger with a form that looks like a spread sheet. Basically down the left side I want to list the students and across the top the assignments and in the middle the students grades. The biggest problem I am having is with the scroll bars. The student list can be long so I need to be able to scroll down but without losing the assignments across the top. Yet the assignment list across the top can also be quit long so I need to be able to scroll left and right but with out losing the names on the left. In other words when I scroll up and down I want the grades in the middle and the names on the left to go up and down but the assignments across the top to stay still, and when I scroll left to right I want the grades in the middle and the assignments across the top to move left to right but the name on the left to stay still.

If I put the assignments in the header of the form then I can scroll up and down without losing them, but I can’t figure out how to get the names on the left to work. I tried putting the names on the left in a subform, but then they don’t move at all and I need them to move up and down, just not left to right. I have also tried using a pivot table and that solves all the scrolling problems but then I can’t add data directly to the form the way I want to. Any suggestions?

In a related question, for the assignments across the top it would be nice if I could just display a continues form horizontally. Does anyone now how to do that?

 

[D-Fresh]

Just a thought... You could the names across the form a few times and set the tab stop property to false... So, every time the first name disappears, the other name is on the right... And when you tab over, it will skip over the names... Again just a thought... Wouldn't be the neatest looking database, but it should get the job done... Hope this helps.

Doug