<div>
That worked great. &nbsp;Thanks.
</div>


<div>
<div class="content wysiwyg-content">
I have a sub-form on a main form that displays in datasheet view mode. &nbsp;But there are several fields across the sub-form and the user has to scroll horizontally to see them all. &nbsp;The subform consumes about 60% of the width of the main form because there is another sub-form next to it.<br />
<br />
My question is this... &nbsp;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? &nbsp;And then when the &quot;zoomed&quot; view of the sub-form is closed, bring the main form and sub-form back to normal?
</div>
</div>


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?

Maybe a wild sub-form question

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.