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

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

    Hello,

    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
    Location
    out on a limb
    Posts
    13,692
    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
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Or...instead of Field Value, use Expression Is:

    Expression Is

    Year([DateFieldName])>2016


    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

    Year([DateField])>Year(Date())

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is 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
  •