Results 1 to 3 of 3

Change font color in Query

  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 online now Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    10,914
    Probably not but you could in a form in continuous form view.
    (RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 Pro - acXP, ac07, ac10, ac13
    If your issue is resolved...go ahead and use the Thread Tools at the top of the thread and mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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