Results 1 to 7 of 7
  1. 05-12-2014, 01:29 PM #1
    Z1nkstar's Avatar
    Z1nkstar
    Z1nkstar is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    TX, USA
    Posts
    145

    Another Hopefully Simple Thing!!!


    Can anyone tell me how to make the number field also a color that would depend on which number was there?
    Click image for larger version.  Name: Capture.JPG  Views: 6  Size: 32.6 KB  ID: 16440
    Reply With Quote Reply With Quote
  2. 05-12-2014, 01:34 PM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Textbox Conditional Formatting probably best approach. Which number field?
    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.
    Reply With Quote Reply With Quote
  3. 05-12-2014, 03:10 PM #3
    Z1nkstar's Avatar
    Z1nkstar
    Z1nkstar is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    TX, USA
    Posts
    145
    It is the Sort Values I want them to be a certain color if its number 0 or if it is number 1, so 0 would be red and 1's will all be blue and so on.
    Reply With Quote Reply With Quote
  4. 05-12-2014, 04:09 PM #4
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Exactly what Conditional Formatting is intended for. Up to 50 conditions possible.
    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.
    Reply With Quote Reply With Quote
  5. 05-12-2014, 04:33 PM #5
    Z1nkstar's Avatar
    Z1nkstar
    Z1nkstar is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    TX, USA
    Posts
    145
    Sorry I am really not the best at knowing things can you elaborate on where I can find these conditional formats???
    Reply With Quote Reply With Quote
  6. 05-12-2014, 04:34 PM #6
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Report or form in design view, select textbox then on the ribbon > Format > Conditional Formatting.

    Access Help has more guidance.
    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.
    Reply With Quote Reply With Quote
  7. 05-13-2014, 07:12 AM #7
    Z1nkstar's Avatar
    Z1nkstar
    Z1nkstar is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    TX, USA
    Posts
    145
    Okay thank You Solved
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. I need a very simple thing!!
    By Z1nkstar in forum Access
    Replies: 2
    Last Post: 05-12-2014, 12:36 PM
  2. How's This SubForm Thing Done?
    By abrogard in forum Forms
    Replies: 6
    Last Post: 07-13-2012, 10:55 PM
  3. Trying hard to do a simple thing !
    By adevine in forum Access
    Replies: 19
    Last Post: 05-16-2011, 07:19 AM
  4. Probably a Strange thing to ask
    By everette in forum Access
    Replies: 3
    Last Post: 03-26-2011, 08:33 PM
  5. Craziest Thing You've Seen/Done
    By Rawb in forum Access
    Replies: 1
    Last Post: 10-25-2010, 02:56 PM

Tags for this Thread

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