UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Another Date Quetion, Office 2010    
 
   
BIGMACBEN
post Feb 24 2012, 08:49 AM
Post #1

UtterAccess Member
Posts: 23
after a date box has been updated on a form, i need to run a small vba to look at it and if the date is older than todays date to change the box background color to red , any ideas please

This post has been edited by BIGMACBEN: Feb 24 2012, 08:50 AM
Go to the top of the page
 
+
Bob G
post Feb 24 2012, 08:51 AM
Post #2

UtterAccess VIP
Posts: 8,138
From: CT
look at conditional formatting for that datebox
Go to the top of the page
 
+
Doug Steele
post Feb 24 2012, 08:52 AM
Post #3

UtterAccess VIP
Posts: 17,636
From: Don Mills, ON (Canada)
Look at Conditional Formatting (in the Font section of the Design tab)
Go to the top of the page
 
+
BIGMACBEN
post Feb 24 2012, 09:07 AM
Post #4

UtterAccess Member
Posts: 23
thanks guys , i wouldnt have dreamed of looking there, i thouht i would have to do it with VBA, cheers
Go to the top of the page
 
+
« Next Oldest · Access Q and A · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 08:09 PM