Access Subform Condional Formatting Not on Printed Form

I have an Access 2007 form and subform that have conditional formatting for several fields' background color.  In form view, both the subform and form display the conditional formatting correctly.  However, in print preview and when printed, the conditional format does not show on the subform.  The conditional formatting on the form is correct when displayed in print preview and the when the form is printed.  The default view for the subform is datasheet view.

I appreciate any help you can provide.
CoopISAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mbizupCommented:
I've seen a few other posts citing issues with some types (not all) of conditional formatting in datasheet subforms.

Try as a test switching the default view to continuous forms (which can be made to look like a datasheet if necessary).

As an aside, even though you CAN print a form if you really want to, they are really not geared towards printing.  Reports are designed for printing, and creating reports from forms is generally pretty straight forward.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
IrogSintaCommented:
I concur with mbizup.  A dedicated report will not only look more professional, it would save on toner/ink because you would avoid printing other areas of the form that are meant just for display.
0
CoopISAuthor Commented:
The subform's conditional formatting does print when the default view is set to continuous form.  With the exception of a couple of controls which I can set to display on screen only, the entry form and printed report are identical in this case so it didn't seem necessary to create a report.

Thanks for your suggestions.
0
mbizupCommented:
Glad to help out.

Yeah - it sounded like a bug with CF in datasheet view.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.