Results 1 to 4 of 4
  1. #1
    megatronixs is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Posts
    91

    conditional formating if the date in field reaches today

    Hi all,

    I'm trying to get a field turn into red if the date that is in the field is today.


    I'm trying to do this in a subform that is set as datasheet view.

    Any help would really be apreciated.

    Greetings.

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Open up the Form in Design View.
    Highlight the field you want to apply the Conditional Formatting to.
    Right-click and select Conditional Formatting.
    Under Condition 1, enter/select:
    Field Value Is equal to Date()
    Choose your formatting color
    Click OK.

  3. #3
    megatronixs is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Posts
    91
    Hi JoeM,

    Thanks it worked really nice, silly of me no to see this :-(

    Greetings.

  4. #4
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    No worries! Glad it worked out for you!

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

Similar Threads

  1. Conditional Formating
    By Derrick T. Davidson in forum Forms
    Replies: 5
    Last Post: 04-13-2013, 07:18 AM
  2. Replies: 3
    Last Post: 02-04-2013, 05:24 PM
  3. Replies: 5
    Last Post: 10-12-2012, 11:00 AM
  4. Conditional Formating for Field Before Group
    By AccessLes in forum Reports
    Replies: 9
    Last Post: 07-20-2011, 12:42 PM
  5. Conditional Formating (Report Field)
    By mlawson6128 in forum Programming
    Replies: 1
    Last Post: 03-10-2011, 11:23 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