Stop Subform scrolling up

[Deutz]

Hi and thanks in advance.
I'm using Access 2003 and have a subform (continuous) that has a set number of rows and columns, so I don't want it to scroll at all. Textboxes in the subform are locked but users can double click them to update data via another form. The problem is that when you click on the subform textboxes in the last row and press any key, the subform scrolls up a little way, leaving a blank area visible at the bottom. You then have to use the mouse wheel to scroll the rows back down so they are all visible again. Subform properties: AllowAdditions = No, Cycle = Current Record, Recordset Type = Snapshot and Scroll bars = Neither, so I don't know what is causing this behaviour or how to stop it.
Thanks
Deutz

 

[John Big Booty]

The only way I know to do that is to set the Sub-Form holder's Enabled property to False, but that will prevent your Double click events from firing

Have you tried playing around with the dimensions of the sub form holder? Or perhaps add a blank footer to the form to fill in the gap?

 

[Deutz]

Did think about that but I have a row of totals textboxes below the subform abbutted up to it so it approximates a spreadsheet like layout so there is no gap between the data and the totals.

 

[John Big Booty]

Are you able to put the totals text box in the subform footer?

 

[Deutz]

Didn't think of that as I originally had the subform in Datasheet view and footer does not display in that format. I'll see if that will work with continuous format.

Thanks

 

[Deutz]

Putting them in the footer works like a dream.

Thanks John!