Screen Size

[pbrown2]

Is there anyway to "set the screen size" so that no matter what a persons PC's screen settings are, the same information will appear?
I.E.
On my computer the formatting shows what is needed, however on anothers computer the screen has to have scroll bars to see the form.

Thank you for any and all help,

PBrown

 

[jrollins]

You can cause reports to change the user's zoom setting to 'Fit to Window'. As for forms, you might enlist the user's cooperation by detecting their resolution setting and encouraging them to change it. Try this code in the Load event of your introductory form:

Private Sub Form_Load()

Dim UserWindowWidth As Integer
Dim UserWindowHeight As Integer
Dim ScreenResolutionCheck As Integer

' Detect User's Screen Resolution - Warn if not = 1024 x 768
UserWindowWidth = Screen.ActiveForm.WindowWidth / 15
UserWindowHeight = Screen.ActiveForm.WindowHeight / 15
ScreenResolutionCheck = 0

If (UserWindowWidth) < 1020 Or (UserWindowWidth) > 1024 Then

ScreenResolutionCheck = _
MsgBox(&quot; Your Screen Resolution is set to &quot; & _
UserWindowWidth & &quot; x &quot; & UserWindowHeight & _
Chr(13) & Chr(13) & _
&quot; THIS DATABASE IS BEST VIEWED WITH&quot; & _
Chr(10) & Chr(13) & _
&quot; SCREEN RESOLUTION SET TO 1024 x 768&quot;, _
vbOKCancel, _
&quot;SCREEN RESOLUTION RECOMMENDATION&quot

End If

Select Case ScreenResolutionCheck

Case 0, 1
DoCmd.OpenForm &quot;WELCOME SCREEN&quot;

Case 2 ' Cancel is selected - Close any open forms/reports - Quit Microsoft Access
CloseAllFormsAndReports
CloseOpeningScreen
DoCmd.Quit acQuitSaveAll

End Select

End Sub

 

[psemianonymous]

As a future reference, design for 800x600 resolution. A lot of users still use it re: their eyesight.

You can maximize screen retail space by setting *ALL* your forms to popup. Popup forms appear in front of the database window, and thus toolbars and such don't get in the way. You must set them all to popup because popups will appear in front of any other type of form.

You can get even more space by setting your form border to &quot;thin&quot; and maximizing the form. This scares the users, though, because it uses *ALL* of your screen space, and Windows seems to disappear. In other words, it's a bad workaround.

There are control resizers available, but I hate them, and they're terribly ugly. (see

http://www.mvps.org

for one such, look for adhResize)

 

[ArkM]

foolio12's advice on 800x600 'standard' is OK. Take into account too: user monitor and/or videocard may have not ability for 'desired' resolution settings.