Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Macros > Using Date() as...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 5622 of 5947
Post > Topic >>

Using Date() as a condition

by =?Utf-8?B?Q2hhZCBMYW5kcnk=?= <ChadLandry@[EMAIL PROTECTED] Jul 11, 2008 at 12:41 PM

I have the following condition, which compares one date field with the 
current date:

[Forms]![Performance_Form]![Milestone_Due_Dates_Subform].[Form]![100pctloan_Const_date_Due]<Date()

The idea is that if the due date is less than today's date it will set the

backcolor value of a control to red.  But, for some reason the macro just 
sets the backcolor to red regardless of the date! 

Does anyone have any ideas?

Thanks!
 




 3 Posts in Topic:
Using Date() as a condition
=?Utf-8?B?Q2hhZCBMYW5kcnk  2008-07-11 12:41:02 
Re: Using Date() as a condition
"Ken Snell \(MVP\)&q  2008-07-12 09:39:37 
Re: Using Date() as a condition
=?Utf-8?B?Q2hhZCBMYW5kcnk  2008-07-14 10:23:01 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Nov 21 14:53:47 CST 2008.