Scroll bar strangeness on subform

[JaredEmery]

I am new to Access and have stumbled through building a
bill-of-materials database. My main form has 4 subforms set to
continuous mode that all exhibit the same scrollbar oddity: if the
number of records the subform displays is even one line larger than
would properly fit in the subform's window, the scrollbar displays a
very tiny slider box as if there were thousands of records to scroll
through. Upon clicking and dragging the scroll box though, it reverts
to its properly scaled size. I imagine it has to do with that the
scrollbar hasn't bothered to check how many records the table contains
before it's drawn and only looks when it's clicked, but that's an
intuitive guess and I have nothing to back it up. Does anyone have a
suggestion to fix this?

Jared

[David W. Fenton]

"JaredEmery" <ja********@westportshipyard.com> wrote in
news:11*********************@g47g2000cwa.googlegro ups.com:

I am new to Access and have stumbled through building a
bill-of-materials database. My main form has 4 subforms set to
continuous mode that all exhibit the same scrollbar oddity: if the
number of records the subform displays is even one line larger
than would properly fit in the subform's window, the scrollbar
displays a very tiny slider box as if there were thousands of
records to scroll through. Upon clicking and dragging the scroll
box though, it reverts to its properly scaled size. I imagine it
has to do with that the scrollbar hasn't bothered to check how
many records the table contains before it's drawn and only looks
when it's clicked, but that's an intuitive guess and I have
nothing to back it up. Does anyone have a suggestion to fix this?

Do you have the record navigation controls displayed? What happens
it you click them to go to the last record? Does the scrollbar then
fix itself? If so, perhaps you could try navigating to the last
record in the subform's Recordsetclone (or, if it's A2K or later,
the form's Recordset) and back to the first record. If the scollbar
problem is a Rushmore issue (i.e., the scrollbar is painted before
the actual number of records is known), this might solve it.

I'm not optimistic, though.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/