That would leave controls along the edges invisible and off the form if he
develops on 1280 by 1040 then displays it on 800 x 600 for example. then
if he gathered all the controls in the upper left corner to protect against
that, it would just look stupid in 1280 by 1040 <g

--
Regards,
Tom Ogilvy

"STEVE BELL" wrote in message
news:Mcknf.9504$Ea6.5376@trnddc08...
You might consider sizing the form to the screen size...

Here's some code Ron posted a long time ago...

'Fill the Screen
Private Sub UserForm_Initialize()
With Application
Me.Top = .Top
Me.Left = .Left
Me.Height = .Hight
Me.Width = .Width
End With
End Sub

--
steveB

Remove "AYN" from email to respond
"Ken Soenen" wrote in message
...

Is there some software technique that could change the size of your
Forms
when you run the Forms with different screen resolutions?
For example: I keep my screen at 1280x1024. When I run the form on say
1024x768, the whole form becomes unnecessarily large and may not even
fit
on the screen.
At a minimum, is there some system item that indicates the current
screen
resolution, that I could query, and then manually(at Form activation)
change the Form and control sizes?

Thanks