You can create a Function to do the zooming, select the Controls to be included, then assign the Function to the DoubleClick event of all of the Controls:
In a Standard Module:
Code:
Public Function fExpand(ctl As Control) As Byte
ctl.SetFocus
DoCmd.RunCommand acCmdZoomBox
End Function
When asked to Save the Module, name it anything except fExpand; having the Function and the Module sharing the same name confuses the Access Gnomes no end!
Then in Form Design View:
- Hold down the <Shift> Key and select (Left Click) each Control to be included
- Go to Properties - Events
- In the appropriate property (OnDblClick, in this case) enter =fExpand([Screen].[ActiveControl])
This will place the Function call in the OnDblClick event for all of the selected Controls, in one fell swoop!
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007