Results 1 to 2 of 2
  1. #1
    dniezby is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Apr 2013
    Posts
    183

    Change field color based on result

    How do I code a field for this:

    If [AGE]<21 then font color = red



    I figure it could go in the OnChange event???
    Last edited by dniezby; 05-01-2013 at 09:42 PM.

  2. #2
    dniezby is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Apr 2013
    Posts
    183
    Just for reference if anyone needs it. Select the field you want to affect, select FORMAT from Form Layout Menu. Then select Conditional Formatting

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

Similar Threads

  1. Replies: 5
    Last Post: 09-18-2012, 12:39 PM
  2. Replies: 8
    Last Post: 04-26-2012, 10:13 AM
  3. Replies: 4
    Last Post: 12-25-2011, 06:31 PM
  4. Replies: 3
    Last Post: 07-05-2010, 10:46 PM
  5. Query result based upon two field conditions
    By diane802 in forum Access
    Replies: 35
    Last Post: 01-08-2010, 06:31 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