Question designing reports and forms to fit a screen

[merlin777]

Can anyone suggest an approach to designing the layout of forms and reports so they fit neatly on a screen?

I want my users to not need to scroll to get to everything. They'll be using 1366x768.

The problem I have is not having something like a print preview to easily judge my layout. The whole saving/running process to check my changes is very long winded. I cant seem to force my laptop into this format either, just to make things a bit trickier....

 

[arnelgp]

for report:

DoCmd.OpenReport stDocName, acViewPreview
DoCmd.RunCommand acCmdSizeToFit


for forms:

DoCmd.OpenForm "yourFormName"
DoCmd.RunCommand acCmdSizeToFitForm

 

[merlin777]

please forgive my ignorance - what do i do with that code?

 

[arnelgp]

if your not calling your report on a module, you can still have the same effect by putting this in the Load event of your report:

Private Sub Report_Load()
SendKeys "%P", True
SendKeys "PZ", True
SendKeys "{ENTER}", True

End Sub

 

[merlin777]

does the code tell access to adjust the size of forms and reports to fit the current screen res?

 

[spikepl]

Google for screen size emulator.

Depending on your operating system and actual resolution of your screen you might find something that lets you set the desired screen size.

 

[merlin777]

nice one. my lap top screen should be able to do that res but it doesnt offer the option.