Unfortunately, using application.screenupdating=false command in vba causes an error :"Method or data member not found" .I am using Access2003 by the way.
thanks,
jon
Sorry, looks like it's as simple as Application.Echo False
See VBA help on the 'Echo Method'.
Here is a clip from a good help page by Tony D'Ambra. The url is
http://www.aadconsulting.com/aadtips.html - Ed :
Resize Form Controls
You can use the InsideHeight and InsideWidth properties of an Access form to dynamically resize controls at run-time. A form's Resize event as well as firing when a user resizes a form, also fires when a form is loaded.
For example, this code will resize a sub-form within a resized form:
-
Private Sub Form_Resize()
-
On Error GoTo ResizeError
-
-
'Turn off screen redraw
-
Application.Echo False
-
Me!subfrmTest.Height = Me.InsideHeight -30
-
Me!subfrmTest.Width = Me.InsideWidth - 30
-
'Turn screen redraw back on
-
Application.Echo False
-
-
Exit Sub
-
ResizeError:
-
-
' NB: Turn screen redraw back on if an error occurs!
-
On Error GoTo 0
-
Exit Sub
-
-
End Sub
-