Resize Form

[Mark]

Hi all,

From the switchboard... users can open a form (single
form) and enter data, then press a command button thats
saves the record and closes the form... the switchboard is
a continuous form, so the user is sent back to this main
page.

My issue is: the form is lengthy, so when the user is at
the bottom of the form and clicks on the save/exit button
the user then gets a blank screen because the switchboard
is at the top of the screen (out of sight). There is an
Access scroll bar on the right/vertical side of the screen
to use, but I am trying to find a way that I can
resize/reposition the focus on the switchboard to be
centered on the screen after closing the form.

I came across one bit of coding on the mvp's website, but
I don't understand how to put it to use.

Any suggestions? THANKS!

 

[Arvin Meyer]

When you switch focus to the switchboard form use a line of code like:

DoCmd.GoToControl "txtControlName"

where txtControlName is the name of a control in the area you want to view.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access