scaling forms on open

[Andy G]

The application I am currently working on will be used by many different
users, most likely with different screen resolution settings. I was looking
around and I came across an article in the Access2000 Vol. 1 Desktop Ed.
ADH. I am using Access 2003 for development.


Option Compare Database

Private frmResize As FormResize

Private Sub Form_Open(Cancel As Integer)
Set frmResize = New FormResize
Set frmResize.Form = Me
Call frmResize.SetDesignCooords(1280, 1024, 96, 96)
End Sub

The database doesn't reconize the FormResize type. Do I need to add a
reference or did I over look something earlier in that chapter?

Thanks.

 

[OfficeDev18 via AccessMonster.com]

Try DoCmd.Maximize in the Open even of your form. It's irrelevant what
resolution you're using.

HTH

 

[Andy G]

Using DoCmd.Maximize is not the answer in this situation.

I need to redimension the form to fit any screen resolution along with all
of the controls within the form at load time, based on its original
design-time dimensions. Can someone please point me to the FormResize class
module and it's code?

Thanks.

 

[George Nicholson]

Check the CD that comes with the book. The FormResize class should be in the
related mdb file for the chapter where you found the reference (chapter 8,
if memory serves...)

HTH,
--
George Nicholson

Remove 'Junk' from return address.