D
David
I was reading on this post about using conditional formatting.
http://msdn.microsoft.com/newsgroup...-DC48AB0DA5C9&dglist=&ptlist=&exp=&sloc=en-us
“select "Expression Is" from the
combo box, and enter a valid boolean expression. Use the entire object
specifier rather than the shortcut Me!.“
I am trying to check the value of a date field in a subform.
Here is the expression I entered after selecting the field in the subform.
Forms![frm_Milestone_Release]![sfrm_Milestones_for_Release].Form.[txt_Status]<Date()
I have also tried to select "Field is" and choosing less than and entering
the expression Date(). Unfortunately, same result.
It seems to key off of the MM/DD and not year. For example if the date is
12/31/06, there is no formatting. If the date is 1/1/07, it is correctly
formatted red.
Can someone help correct my errors?
http://msdn.microsoft.com/newsgroup...-DC48AB0DA5C9&dglist=&ptlist=&exp=&sloc=en-us
“select "Expression Is" from the
combo box, and enter a valid boolean expression. Use the entire object
specifier rather than the shortcut Me!.“
I am trying to check the value of a date field in a subform.
Here is the expression I entered after selecting the field in the subform.
Forms![frm_Milestone_Release]![sfrm_Milestones_for_Release].Form.[txt_Status]<Date()
I have also tried to select "Field is" and choosing less than and entering
the expression Date(). Unfortunately, same result.
It seems to key off of the MM/DD and not year. For example if the date is
12/31/06, there is no formatting. If the date is 1/1/07, it is correctly
formatted red.
Can someone help correct my errors?