I have a sub-form on a main form that displays in datasheet view mode. But there are several fields across the sub-form and the user has to scroll horizontally to see them all. The subform consumes about 60% of the width of the main form because there is another sub-form next to it.
My question is this... Is there a way, via an onclick event of a command button, to make the sub-form fill the screen so the user can see more of it? And then when the "zoomed" view of the sub-form is closed, bring the main form and sub-form back to normal?