Datasheet view scroll bars

H

hughess7

Hi all

I have a form which displays data in a spreadsheet format. I had designed
this as a continuous form so I could have headers and footers with buttons,
and column headings formatted. It all worked ok until I wanted to 'freeze'
the first column so when you scroll horizontally you always see that field
displayed on screen.

I searched the newsgroups and google and finally settled on a main form with
the headers and footers for my buttons and a subform as a datasheet for the
actual data. The only problem I keep having is losing the vertical scroll bar
- is this a fault or am I not laying things out properly?

Sue
 
J

Joan Wild

hughess7 said:
I searched the newsgroups and google and finally settled on a main form
with
the headers and footers for my buttons and a subform as a datasheet for
the
actual data. The only problem I keep having is losing the vertical scroll
bar
- is this a fault or am I not laying things out properly?
Click to expand...


The vertical scroll bar will only appear when it's needed (i.e. there are
more records than can appear in the subform control).
 
H

hughess7

Thanks Joan, there are more records than can fit on subform therefore scroll
bar IS needed - but not shown (sometimes!). I've decided to forgo the 'freeze
column' function and reverted back to a continuous form view as it looks so
much better. Shame you can't freeze columns in this view :-(

Sue
 
Top