White space in datasheet view

[maw230]

How can I remove the white space that follows the last record in my datasheet forms? Please refer to attached image. This happens in two different forms, scrolling in two different directions.

 

[CJ_London]

you can change the colour, or reduce the size of the sheet - see this link

http://www.access-programmers.co.uk/forums/showthread.php?t=259205&highlight=datasheet

Post #4 is probably what you want

 

[maw230]

you can change the colour, or reduce the size of the sheet - see this link

http://www.access-programmers.co.uk/forums/showthread.php?t=259205&highlight=datasheet

Post #4 is probably what you want

Thanks, that might be what I have to do. When you say reduce the size, what do you mean? Can I simply tell the form to eliminate all space below the add record sign?

I'm actually more concerned with the horizontal scrolling form, for which I did not paste a screenshot.

 

[CJ_London]

you'll need some vba code to work out how may rows can be displayed (recordcount) and adjust the height of the form accordingly. Note this won't work with a tabbed display (A2007 & later) datasheet

If the frm is actually a subform, then you would adjust the height of the subform control

However I don't have time to spend on this so you'll need to research further

 

[maw230]

you'll need some vba code to work out how may rows can be displayed (recordcount) and adjust the height of the form accordingly. Note this won't work with a tabbed display (A2007 & later) datasheet

If the frm is actually a subform, then you would adjust the height of the subform control

However I don't have time to spend on this so you'll need to research further

Hard to believe it isn't a built in form property, but I may be unaware of some grand design reasoning for that. Either way, thanks for the help.

Edit: since we're focused on vertical, does anyone have a solution for this problem when scrolling horizontally? See image.

 

[maw230]

I've adjusted sizes and every other property I can think to, but the datasheet form still wants to stretch on and on which produces an undesirable user experience.

 

[CJ_London]

Are you viewing your datasheet in tabbed view or overlapping? It sounds like you are using the former. If so go to file>Options>current database and change Document window options to Overlapping windows.

If you don't want to do this you can:

create a new blank 'main' form and add your datasheet as a subform, sized as you require
or
make your datasheet popup and modal (form properties>other)

 

[maw230]

The Overlapping Windows setting didn't make a difference. Thanks for the other suggestions. I will look into these if the user decides they just can't stand the white space.

 

[CJ_London]

you can change the colour from white as per the link in post #2