Access Subform Condional Formatting Not on Printed Form

Posted on 2013-09-26
Medium Priority
Last Modified: 2013-10-10
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.
Question by:CoopIS
  • 2
LVL 61

Accepted Solution

mbizup earned 1000 total points
ID: 39524817
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.
LVL 29

Expert Comment

ID: 39525137
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.

Author Comment

ID: 39525231
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.
LVL 61

Expert Comment

ID: 39525244
Glad to help out.

Yeah - it sounded like a bug with CF in datasheet view.

Featured Post

7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
There may be issues when you are trying to access Outlook or send & receive emails or due to Outlook crash which leads to corrupt or damaged PST file. To eliminate the corruption from your PST file, you need to repair the corrupt Outlook PST file. U…

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question