scaling forms on open

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andy G - 28 Nov 2005 16:24 GMT

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.

Reply to this Message

OfficeDev18 - 28 Nov 2005 16:46 GMT

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

HTH

>The application I am currently working on will be used by many different
>users, most likely with different screen resolution settings. I was looking
[quoted text clipped - 15 lines]
>
>Thanks.

Signature

Sam

Reply to this Message

Andy G - 28 Nov 2005 19:46 GMT

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.

> Try DoCmd.Maximize in the Open even of your form. It's irrelevant what
> resolution you're using.
[quoted text clipped - 21 lines]
>>
>>Thanks.

Reply to this Message

George Nicholson - 28 Nov 2005 22:25 GMT

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,

Signature

George Nicholson

Remove 'Junk' from return address.

> Using DoCmd.Maximize is not the answer in this situation.
>
[quoted text clipped - 30 lines]
>>>
>>>Thanks.

Reply to this Message