Changing formats

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

I recently upgraded computer including a larger monitor.
When I now run my databases, they fill about 25 percent
of the new screen. How can I enlarge my databases to fill
more of the new screen? A couple of other questions -
when screen previewing a report, how can I get the
preview to automatically open at 150%? Also on reports -
how can I ensure a group header is attached to its data
when a new page is opened. ie. the group header should
not be on one page and the group data on the next.
many thanks
 
I recently upgraded computer including a larger monitor.
When I now run my databases, they fill about 25 percent
of the new screen. How can I enlarge my databases to fill
more of the new screen?
Click to expand...

The display resolution on your older computer, where you originally
developed your database, was set to a lower resolution than your current
computer. It is possible to add code to your application to adjust the
display based on the current screen resolution settings. Go to the
following link and download the Form Scaling/Resizing Tool.

http://www.developershandbook.com/downloads.htm

If you already own a copy of the Access xxxx Developer's Handbook by Ken
Getz et al, the code is also available there
A couple of other questions -
when screen previewing a report, how can I get the
preview to automatically open at 150%?
Click to expand...

DoCmd.OpenReport "MyReport", acViewPreview
DoCmd.RunCommand acCmdZoom150
preview to automatically open at 150%? Also on reports -
how can I ensure a group header is attached to its data
when a new page is opened. ie. the group header should
not be on one page and the group data on the next.
Click to expand...

You can adjust the Keep Together property in the Group's Header Properties
in your report's design view.
 
The amount of space that the interface for access takes up on you
screen has nothing to do with the size of your screen. When you go
the new monitor it was probably set to a different resolution than you
old monitor. A normal resolution is 800 X 600 or 1024 X 768. 1024
768 is probably more the industry standard nowdays. You should b
creating forms to that resolution.

You can change your resolution or find out what it is by right clickin
on your desktop - then clicking on properties - then click on th
settings tab of the dialog box that comes up.

On that dialog box you will see a control that says screen area - I
should tell you what resolution you currently are using and allow yo
to change it.

If you want to take up more real estate on your screen you can maximiz
your forms, but that fills the screen with blank space in most cases.
Otherwise you will need to change the size of your forms and th
controls on the forms. The amount of space taken up by your interfac
shouldn't be the controlling factor though as long as you are gettin
all the info you want on the screen
 
The amount of space that the interface for access takes up on you
screen has nothing to do with the size of your screen. When you go
the new monitor it was probably set to a different resolution than you
old monitor. A normal resolution is 800 X 600 or 1024 X 768. 1024
768 is probably more the industry standard nowdays. You should b
creating forms to that resolution.

You can change your resolution or find out what it is by right clickin
on your desktop - then clicking on properties - then click on th
settings tab of the dialog box that comes up.

On that dialog box you will see a control that says screen area - I
should tell you what resolution you currently are using and allow yo
to change it.

If you want to take up more real estate on your screen you can maximiz
your forms, but that fills the screen with blank space in most cases.
Otherwise you will need to change the size of your forms and th
controls on the forms. The amount of space taken up by your interfac
shouldn't be the controlling factor though as long as you are gettin
all the info you want on the screen
 
Generally, i put the headers for my groups in the page header section.
But it depends on what kind of data you want to display based on th
group. Is the header the same for every group, if so do the headers o
the page. If the headers are different for every group then do them a
both page and group levels.

By the way if you hear of a method to zoom the report automatically,
would be interested to hear of it. It sounds like it should be doabl
but I don't find any references to it
 
Generally, i put the headers for my groups in the page header section.
But it depends on what kind of data you want to display based on th
group. Is the header the same for every group, if so do the headers o
the page. If the headers are different for every group then do them a
both page and group levels.

By the way if you hear of a method to zoom the report automatically,
would be interested to hear of it. It sounds like it should be doabl
but I don't find any references to it
 
Here, I found this by doing a search on "Zoom Preview" on this forum.
You could have done the same. Anyway, here is what I found.
 
Here, I found this by doing a search on "Zoom Preview" on this forum.
You could have done the same. Anyway, here is what I found.
 
The acCmdZoom150 produces an error message 2046 stating
that Zoom150% is unavailable.
I have adjusted the Keep Together property in the Group's
Header properties, but the text and heading still split.
grateful any further advice
thanks
 
Back
Top