Results 1 to 2 of 2
  1. #1
    tagteam is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    486

    conditional formatting for field if null and greater than x days from a different field

    I am trying to use conditional formatting to say:

    If field 1 has a date and field 2 does not and today is greater than 30 days from field one make the textbox red.

    So for example

    Invoice date = 12/1/16
    Payment date = null



    This scenario should make payment date have a red background because it is still null and is greater than 30 days from the invoice date

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Something like:

    IsDate([Invoice Date]) AND IsNull([Payment Date]) AND [Invoice Date] < Date() - 30
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Conditional formatting for a empty field
    By Bradex in forum Forms
    Replies: 4
    Last Post: 03-18-2016, 09:11 PM
  2. Conditional Formatting on datetime field
    By Delta729 in forum Access
    Replies: 3
    Last Post: 05-06-2015, 03:37 PM
  3. Conditional Formatting based on another field - Part II
    By Harley Guy in forum Programming
    Replies: 8
    Last Post: 10-17-2013, 12:46 PM
  4. Replies: 5
    Last Post: 10-15-2013, 07:49 AM
  5. Replies: 18
    Last Post: 09-30-2011, 06:41 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