Results 1 to 3 of 3
  1. #1
    Brian62 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2009
    Posts
    147

    Change font color in Query

    Is it possible to change the text color in query view when it shows in datasheet view? I would like to change the text to red when the query runs.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Probably not but you could in a form in continuous form view.

  3. #3
    magicrat is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2013
    Posts
    2
    You can do "some" conditional formating of query results. Specifically, for number data types.

    Right-click on the column you want to apply the conditions to in query design view and select properties.

    In the properties box that opens, you may specify conditional color formatting for numbers ... like this:

    $#,###.000[Blue];($#,###.000)[Red];$0.000[Blue];$0.000[Blue]

    I am looking for ways to do conditional text (meaning other than number data types) ...

    But for numbers, this DOES work without having to build a form or report.

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

Similar Threads

  1. Changing font color based on criteria
    By Pattie Weaver in forum Reports
    Replies: 5
    Last Post: 11-02-2010, 03:38 PM
  2. Change as per condition font color
    By miziri in forum Programming
    Replies: 1
    Last Post: 08-20-2009, 04:23 AM
  3. Color change in form filed
    By miziri in forum Programming
    Replies: 3
    Last Post: 08-15-2009, 04:53 PM
  4. Color/font change in subform
    By AndyKim in forum Forms
    Replies: 9
    Last Post: 06-24-2009, 04:34 PM
  5. change cell color
    By bishop743 in forum Programming
    Replies: 0
    Last Post: 02-01-2009, 11:00 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
  •  
Other Forums: Microsoft Office Forums