Conditional Formating

[dan.cawthorne]

Hi,

I need some help in getting a particular Bound text box colour to
change color depending on the date value in another bound text box,

i can get that date box to change color in the conditional formating,
but i cant get the other one, to change from date text box


can any one help me?

 

[Dale Fye]

Make it easy on us. Give us names for the controls.

basically, what you need to do is select the bound text box.

Select conditional formatting

change the first dropdown in the condition to "Expression is" or something
like that,

Then, in the textbox to the right put something like [DateField] < #9/15/2009#

Then, set your foreground and background colors.

Another way to go about this is to use the forms Current event to call the
date textboxes AfterUpdate event. Then, in the AfterUpdate event, have some
code that manually sets the background color of the other control based on
whatever is in the bound date textbox. But this method won't work in a
continuous form.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[fredg]

Hi,

I need some help in getting a particular Bound text box colour to
change color depending on the date value in another bound text box,

i can get that date box to change color in the conditional formating,
but i cant get the other one, to change from date text box

can any one help me?

Right-Click on the control you wish to conditionally format.
Select Conditional Formatting.
Set Condition1 to
Expression Is.
In the next box, write:
[YourDateControl] > #somedate#
Select the color.
Save the changes