Q: Is there a "freeze rows" concept (similiar to freeze cols)?

[A C]

Hi

Is there a way to freeze rows in datasheet view? We are freezing columns
which is great but want the first few records frozen when the user scrolls
as well. These first few records contain very useful info which is nice to
always have on screen.

Must be in datasheet view! as we are freezing cols and that only seems to
work in datasheet mode (or can we do that some other way?).

Putting the useful info into the field headings doesnt work well as it makes
them far too long, and we cannot seem to get the header/field text to go
over multiple lines in datasheet view - it just makes really wide fields.

All help appreciated.
Regards
A

 

[(PeteCresswell)]

Per A C:

Is there a way to freeze rows in datasheet view? We are freezing columns
which is great but want the first few records frozen when the user scrolls
as well. These first few records contain very useful info which is nice to
always have on screen.

Must be in datasheet view! as we are freezing cols and that only seems to
work in datasheet mode (or can we do that some other way?).

I haven't found anything.

But there's a pretty easy workaround: just add a subform with no scrollbars
whose .RecordSource either returns only the desired subset or whose size is
limited so the user sees only the desired rows.

Or if you want to go all the way, open up a recordset and just push the values
into fixed fields at the top of the form.