Formatting Problem on Printing Form

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

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.
 
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
 
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
 
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.
.
Click to expand...
.
Click to expand...
 
Back
Top