Subform question re: datasheet view

  • Thread starter Thread starter TotallyConfused
  • Start date Start date
T

TotallyConfused

I am working with Access 2003. I have a main form and subform. My subform
is in datasheet view. I would like to know if in a subform - datasheet view
you can freeze the column headings so that when you scroll down you can keep
the column heading? (like in Excel you can freeze columns/row). Thank you
for any help you can provide.
 
The column headings should be the field names and there is no freezing to be
done.

Are you inserting a record with headings? If so the is the wrong thing to
do in Access database.
 
Thank you for your response. No I am not inserting records with headings.
Would like to have the headings frozen. This would be helpful when you have
a long list of records in subform.
 
You can't freeze just the headings, but you can freeze columns. Open the
form in datasheet view, then from the Access menu, select Format and there
will be options to freeze and unfreeze columns. Then save the form.
 
Alternately, you could create the subform as a continuous tabular form and
make it look like a datasheet form by eliminating all the space between the
data field. I believe the form wizard puts the headers in the Header section
of the form by default, so your headers will stay in place as you scroll in
the subform.
 
If the space you have allocated in the main form is smaller than you sized
the subform when you designed it you would have TWO scroll bars - one to move
the sub up and down within the main form assigned space and another to scroll
the actual datasheet of the subform.
So, if the sub fits, the scroll will only move the records in the subform
leaving the column heading visible.
 
Back
Top