Formatting Problem on Printing Form

From: Kevin Sprinkel (anonymous_at_discussions.microsoft.com)
Date: 03/16/04 

Date: Tue, 16 Mar 2004 07:03:03 -0800

Bruce,

I can't specifically address your stated problem, but I
can say that Access just doesn't provide much
functionality or flexibility in printing forms.

The standard approach to printing something that *looks*
like your form is to create a report, which is much more
flexible. You can then use the value of the key field
control in the displayed record as filtering criteria,
i.e.,

Dim strDocName As String
Dim strWhere As String
strWhere = "[keyfield] = '" & Me!yourtextbox & "'"
strDocName = "yourreportname"
DoCmd.OpenReport strDocName,,, strWhere

Place a command button on your form and place the above
code in its OnClick event.

HTH
Kevin Sprinkel

>-----Original Message-----
>I have an Access form that has some intermittent
>formatting problems when printed. When printed, any
>bitmaps on the form come out poorly, i.e. the bitmaps are
>missing or very pixely and the lines on the form look
>thicker in some places or offset in others. In addition
>any checkboxes don't show up on the form. This only
>happens on two particular printers and interestingly the
>formatting is different depending on whether
>the "File", "Print" menu is used or the "print current
>record" command button is used. Since this happens only
on
>certain printers I believe it's related to the printers,
>but why the does the difference in printing methods
effect
>it? Has anyone heard of a problem in Access that might
>cause this? Both printers are network printers. We have
>10 users of the database as well as different versions of
>Access and Windows. Thanks for any help.
>.
>