Not printing conditional formatting

[Anthony]

I have conditional formatting on a form. It changes the text color and
background color in certain conditions. Is there a way to NOT show the
colors when I PRINT the form? The reason, is that some people only have
black toner printers, so when you print certain colors (like RED) it shows up
VERY dark (hard to read). I would like to print it with black text and white
background even if the conditional formatting has it white text with red
background. I am thinking, maybe it would work if I printed the form via a
report instead of just printing the form???

Thanks

 

[Ryan]

Why not just make another form with the exact same information, remove the
conditional formating, and from the original form have a command button that
opens the new form and prints it?

 

[Arvin Meyer [MVP]]

When possible, always print from a report. Reports have events and grouping
and sorting capabilities not available in forms, and generally present a
much better final product. You can easily get started on creating a report
by right-click on the form in the database window, and choosing: Save As
Report, then giving it a name. Now go in and make the modifications to make
it print the way you desire.

 

[Anthony]

Hmm, that sounds like it would work. I will definitely try it if I can
figure out how to get a command button to do 2 things (open a form AND then
print it). However, I was hoping for something a little more elegant.
Also, we currently print all the forms in the database using the FILE >
PRINT function, so putting a button on a form would be a change from our
normal printing protocol. I have some very non-techie users, so doing
something different will require some retraining.

Thanks.

 

[Anthony]

Oh, WOW. Thank. I didn't know you can do that. I will try it. As I
stated before, with my non-techie users it will require a little retraining
but that's OK.

Thanks.

 

[Ryan]

Arvin makes a good point about reports, and if your looking for something
more elegant then that is the way to go. However, you can make forms look
elegant as well. Here is the code for the command button with a name of
"Print" to open the other form and print it. If you give me the name of your
table or query and the primary key field I will give you the exact code.

Private Sub Print_Click()
If Me.Dirty Then
DoCmd.RunCommand acCmdSaveRecord
End If

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "YourOtherFormName"

stLinkCriteria = "[ThePrimaryKeyField]=" &
Me![TheTextboxOnCurrentFormWithThePrimaryKey]
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.PrintOut acSelection
DoCmd.Close acForm, "TheNewFormName"
DoCmd.Close acForm, "TheOriginalForm"
End Sub

 

[Arvin Meyer [MVP]]

You should be able to add a print button to the report that will open it to
the record(s) you want, so the only retraining will be to click on the
button.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com