Filling Screen with Application

[Guest]

Does anyone know what's going on here:

I wish to fill the display screen with the contents of a form. The form's
on-load event populates an ActiveX control that produces a grid of data. Ths
uses some 75 lines of code.

I then use the following lines to firstly expand the Access window to fill
the screen, then expand the form to fill the window.

DoCmd.Maximize
Application.RunCommand acCmdAppMaximize

With activexcontrol_name
.Height = Me.InsideHeight - 1000
.Left = 0
.Width = Me.InsideWidth
End With

On about 25% of user PC's the form hangs - no error message, nothing - I
have to exit using Task Manager. The other 75% works perfectly.

If I split the code and have the first two lines at the top of the module
then the problem is solved. What's going on? Is it that the instruction to
maximise the application hasn't completed before the form tries to fill it
perhaps?

Any ideas appreciated.

Thanks.

 

[Albert D. Kallal]

You might want to check with the grid control maker, and see if they support
ms-access.

You also can consider using the built in abilities to display a grid, they
are fast, easy, powerful, and no activex

Here is some screen shots that will give you ideas...and, you will not need
75 lines of code to fill the grid anymore!!
http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm