Print Current Record

M

Mike

Hi,

On my form I have a print current record command button.
when I use this option it prints the background color of
my form as well. How do I turn off the background color
when printing a current record?

Thanks,

Mike
 
G

Gary Miller

Mike,

You can't turn it off just for printing. Normally, you would
use a report to print your information, rather than a form,
as that is what they are designed for.

If you really feel that you need to print the form itself I
suppose that you could add code to change the BackColor of
all of your form sections before the print command and then
change it back afterwards. Here is a little code to toggle
back and forth from grey to white to give you something to
start with...

If Me.Detail0.BackColor = 12632256 Then
Me.Detail0.BackColor = 16777215
Else
Me.Detail0.BackColor = 12632256
End If

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top