Results 1 to 2 of 2
  1. 03-15-2016, 12:32 PM #1
    barby.pava
    barby.pava is offline Novice
    Windows XP Access 2002
    Join Date
    Feb 2016
    Posts
    11

    Change color for pivot table access

    Hi,
    i need help with my pivot table in access.


    i have a pivot table based on a query i need that the RunNumber column change color based on the Run name (G/... need Green , O/.. oRANGE , B/.. blue) and the expr1 where there is a name is color too.

    check my attached for more infoClick image for larger version.  Name: PIVOT TABel.png  Views: 9  Size: 21.2 KB  ID: 24096
    Reply With Quote Reply With Quote
  2. 03-15-2016, 03:42 PM #2
    NTC
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    I do not believe one can control color in queries nor tables
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Change color of combo-box text based on Query/Table comparison
    By T_Tronix in forum Access
    Replies: 8
    Last Post: 11-20-2013, 01:03 PM
  2. Change ODBC of Pivot Table from DSN to DSN-less going to SQL Server
    By rjbautista20 in forum SQL Server
    Replies: 1
    Last Post: 07-15-2013, 08:34 AM
  3. Change Pivot Data Source from MS Access to SQL Server
    By rjbautista20 in forum SQL Server
    Replies: 3
    Last Post: 06-24-2013, 11:36 PM
  4. Change color of control using data in another contro, this is for an access report.
    By n2mee in forum Access
    Replies: 3
    Last Post: 05-30-2013, 08:03 AM
  5. Referencing Table Field Value to Change Back Color (with if/iif VBA/expression)
    By Heatshiver in forum Reports
    Replies: 8
    Last Post: 04-26-2012, 10:13 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums