Formatting Problem on Printing Form

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

Date: Tue, 16 Mar 2004 11:24:09 -0800

Thanks for the info, Kevin

Bruce

>-----Original Message-----
>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.
>>.
>>
>.
>