Print Current Record

  • Thread starter Thread starter Mike
  • Start date Start date
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
 
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
________________________
 
Back
Top