UserForm Window size setting

[Guest]

Is there a way with a UserForm to set the size dynamically on a users PC so
that the UserForm will take the full screen apart from the Windows related
Start tab ?

thanks
Scott

 

[Incidental]

Hi Scott

you could try checking out the solution to this sort of problem posted
by Tom Ogilvy back in 2004 it is a very good approach to sort of
problem as some of the other methods i tried before coming across
Tom's post can lead to having to add a ton of code to move and resize
your controls which depending on how much you have on your form can be
a real pain in the a$$

http://groups.google.co.uk/group/mi...&lnk=gst&q=screen+resolution#c10e257060e8cb82

hope this helps you out

Steve

 

[scott56hannah]

Steve,

Thanks for that...I used that approach which allows for the screen
resolution to be determined and then a different form shown.

But the only way I could get it to work was to have a separate form and also
separate procedures for validation of the form for each screen resolution. Is
there anyway to parameterise a form name so that when calling a particular
form based on the screen resolution a different collection is used....

at the moment I have things like.....

VendorEntry_1280x1024.VendorFirstName =
VendorEntry_1280x1024.VendorDataListBox.List(i, 0)
VendorEntry_1280x1024.VendorLastName =
VendorEntry_1280x1024.VendorDataListBox.List(i, 1)
VendorEntry_1280x1024.VendorSalePropertyAddress =
VendorEntry_1280x1024.VendorDataListBox.List(i, 2)

Where the form has been set to the resolution.....is there a way to call a
particular routine based on a different form ?

SCott