Printing Access

S

Sam

Hi people,

I have this problem. I have a Access database filled with data. But
everytime I print, the grid that appear on the paper is squeeze into the top
left corner and not spread out as it appear on the screen. Meaning, the grid
size is not align to the size of the paper. What could be the problem? This
is a urgent problem as I have to submit my database for audit soon.
 
J

Joan Wild

Sam said:
Hi people,

I have this problem. I have a Access database filled with data. But
everytime I print, the grid that appear on the paper is squeeze into
the top left corner and not spread out as it appear on the screen.
Meaning, the grid size is not align to the size of the paper. What
could be the problem? This is a urgent problem as I have to submit my
database for audit soon.

Check in the page setup dialog, on the Page tab, that you have checked 'Use
default printer' rather than specific printer.

Also you may find that changing your default printer to another;
opening/saving each report; and then switching back
may work.
 
S

Sam

Yah, I have done that. One the print preview screen, the alignment is all
correct. but after printing, it went all wrong. All stuck at the left hand
corner.
 
S

Sam

I have tried using that method. it still remain the same. I am using the
default printer. Not any specfic printer.
 
G

GM

Is your grid size the same as the 'Page Setup' > Page Size (minus margins)?
I've found that if your grid is smaller it gets stuck to the top left.
 
K

Kimby@Ecology

I had a variation on this problem and finally fixed it! (Well, an
acquaintance who is an Access expert who had seen and solved the problem
before told me how to fix it.)

The problem lies with how Access processes graphics. Sometimes Access does
not play nicely with graphic elements, such as lines and boxes. I was given
two possible solutions:

(1) The workaround solution is to print your report to a PDF file and print
the PDF.

Or (2) the real solution is to use a PostScript driver.

I used solution #2 by tracking down a printer on our network that was
already PostScript-enabled. Report printed perfectly -- just like it
appeared in the Print Preview. When I tried it without PostScript, it went
back to printing the text OK but the graphic elements all wrong.

Hope this info is still useful.
 
Top