Problem with MS Access 2000.  I want to use a form in Datasheet view
that will allow me to not anly freeze colums to the left (So they are
always visible) but also to freeze rows at the bottom so totals of
entries can be seen.  I can sort of do this using continous form view,
but this view forces the user to scroll through an entire record to
move down one row (Or worse, use the mouse!).  This project involves a
table with approximately 70 fields.  Also, I am using VB code to
change the names of the fields in the form to match those of the table
it is based on (Changing dates that were cross tabbed) and when the
data is updated by the user, I will use VB code to un-cross tab back
into a normal table.  The VB code is already written, and I suspect I
can use VB code to generate the totals at the bottom on the fly.  So
long as when the user scrolls over to the right, the totals scroll
along and line up.

Hope someone can help.  I have been reading every source I can come up
with to give me ideas.

---

Clarification of Question by charles_smith-ga on 08 Sep 2003 08:51 PDT

No responses so far.  Is what I want to do possible?  Do I need to
increase the list price?

I am pulling my hair out.