Results 1 to 3 of 3
  1. #1
    cduveE6 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    2

    Conditional Formatting in a Sub Report


    Hi,

    I'm struggling with a problem I'm having with conditional formatting in an access sub report. I have a main report and 9 sub reports (Monday-Sunday + Total + Targets) each linked to a date on the main form. Each value in the sub reports are compared with the values in the targets sub report and conditional formatting applied.

    Basically everything works fine in Report View but conditional formatting disappears in print preview. Any ideas? (Back style is set to Normal)

    Hope that makes sense... if not I can clarify!

    Thanks

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    I tested this and no problem. Cannot replicate the issue. Do you want to provide project for analysis?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    cduveE6 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    2
    Quote Originally Posted by June7 View Post
    I tested this and no problem. Cannot replicate the issue. Do you want to provide project for analysis?
    Very strange... I opened the file this morning to prepare it to upload here but it worked as expected... Not sure what was going on there but I wasted a few hours trying to figure it out! Sorry for wasting your time!!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 03-14-2011, 08:38 AM
  2. #Name? Conditional Formatting Report
    By stosh59 in forum Reports
    Replies: 5
    Last Post: 01-10-2011, 02:40 PM
  3. Conditional Formatting
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-30-2010, 09:31 PM
  4. Conditional formatting in crosstab report
    By squirrelmaster in forum Reports
    Replies: 0
    Last Post: 06-24-2010, 06:31 AM
  5. Conditional formatting in report
    By RickM in forum Access
    Replies: 1
    Last Post: 09-10-2009, 06:21 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums