R
Rick in NS
I have several forms that call a second forms via a command buttons. The
called forms are popups and appear in datasheet view. To prevent users from
permanently resizing columns or changing the order of the columns in the
datasheet I have used the following code in the called form's load event
(have also tried putting it in the called form's open event):
Me.Type.Columnwidth = 1200
Me.Type.Columnorder = 1
Me.Address.Columnwidth = 2550
Me.Address.Columnorder = 2
etc......
I have noticed this code degrades the load time of the form greatly.
Commenting the code out results in the called forms loading in a flash. When
the code is used the form grinds for 3-4 seconds before display.
Any suggestions on how to speed the load time of these datasheet forms would
be appreciated.
called forms are popups and appear in datasheet view. To prevent users from
permanently resizing columns or changing the order of the columns in the
datasheet I have used the following code in the called form's load event
(have also tried putting it in the called form's open event):
Me.Type.Columnwidth = 1200
Me.Type.Columnorder = 1
Me.Address.Columnwidth = 2550
Me.Address.Columnorder = 2
etc......
I have noticed this code degrades the load time of the form greatly.
Commenting the code out results in the called forms loading in a flash. When
the code is used the form grinds for 3-4 seconds before display.
Any suggestions on how to speed the load time of these datasheet forms would
be appreciated.