Alternate Background

[data808]

I'm looking for an option to change the background on some of my forms but I only want it for the user to see. I don't want it to print. Does anyone know which option to use for this?

[trevor40]

When you select print/print preview the form will show as seen, with whatever bg you have.
What you could do is use vba to

1. hide form me.visible = false
2. change bg color me.detail.backcolor = "whatever"
3. print form docmd.print "form name", acpreview
4. restore bg color me.detail.backcolor = "whatever"
5. unhide form me.visible = true

this way the user won't see the changes
the code would go in the on click event of your print button.

[data808]

That seems like a lot of work for what I need. I do see an option when I right click on the detail section of the form in design view that there is an alternate fill/back color option. Do you know what this is used for?

[June7]

That's to create alternating background for each record so that on datasheet or continuous form it's easier to distinguish each record.

[trevor40]

It may be a lot of work, but it may be your only solution.

[amrut]

One more option (easier for bound form)-
Create an identical form with desired background and use it for printing.

[June7]

Or print a report.

[data808]

Ahh. Thanks guys for all the replies.