Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008

    Unanswered: How do you Highlight Years using Conditional Format in Access 2013?


    How would I create a conditional format in an Access 2013 form field to highlight a year greater than 2016 or dates greater than 12/31/2016?

    I did this, but it is highlighting all dates.

    Field Value is Greater than 2016

    Highlight Red

    Appreciate the help. Thanks.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    highlight all dates...
    are you by any chance using continuous forms?

    what expression have you tried?

    a quick test in A2010 suggests setting a rule

    where the value of the column/control is greater than CDate("31/12/2016") shoudl work, assuming that the source column is a date time column
    Last edited by healdem; 05-04-16 at 04:15.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    Or...instead of Field Value, use Expression Is:

    Expression Is


    If you don't want to hard wire the year...but wanted to highlight dates in future years (i.e. current year is 2016...highlight years 2017, 2018, 2019, etc.)

    Expression Is


    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts