Conditional Formatting Access 07

[Wigley]

I can use the sorting feature on my date columns in a continuious form but
when I add a Conditional Format equal to a simple date value to one of them,
I get a message stating "You have entered an expression that has an invalid
reference to the property page - The property may not exist or may not apply
to the object you specified" This is true on all of my fields but when I
remove the formating, the message does not appear.
How do I stop this?

 

[boblarson]

What are you entering into the Conditional Formatting?
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

 

[Wigley]

I am using Field Value Is - equal to #12/30/2030#

 

[boblarson]

If you are wanting the field that has that date to show up as formatted when
that date occurs, and it won't occur for 23 years, so I'm not sure what you
are doing, it would be just

12/30/2030
or if it tells you it needs the # delimiters it would just be

#12/30/2030#

entered into the conditional format formula section - No equal sign, or
words to the effect of equal to.

If you want a different text box to be the criteria then you would change
the "Field Value Is" to "Expression Is" and the formula would be
[YourOtherFieldNameHere]=#12/30/2030#



--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

 

[Linq Adams via AccessMonster.com]

Since Access is notorious for sending error messages that don't really
reflect the actual error, I'll ask what seems like an obvious question: Are
you sure the field you're doing the CF on is, in fact, a date field, as
opposed to a text field that you're entering "dates" into?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com

 

[Wigley]

Your assumption is correct, it is a date field. This same CF works just fine
in Access 03 but I get the message in Access 07. The access file was
converted from 03 to 07. After I answere OK to the error message, the sorting
is correct and the formatting is correct.

 

[Wigley]

I am using the predefined aspects of CF and the # is added automatically by
access. I am not using anything but the predefined functionality of the built
in formatting formulas - no = sign or other words. 12/30/2030 is a value we
use to prevent an action from occuring becasue it is 23 years from now.

If you are wanting the field that has that date to show up as formatted when
that date occurs, and it won't occur for 23 years, so I'm not sure what you
are doing, it would be just

12/30/2030
or if it tells you it needs the # delimiters it would just be

#12/30/2030#

entered into the conditional format formula section - No equal sign, or
words to the effect of equal to.

If you want a different text box to be the criteria then you would change
the "Field Value Is" to "Expression Is" and the formula would be
[YourOtherFieldNameHere]=#12/30/2030#



--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

I am using Field Value Is - equal to #12/30/2030#