Conditional formatting not working as expected (A2007)

D

Dale Fye

I've got 4 unbound textboxes which represent start date, start time, end
date, end time. These textboxes are visible and initially get filled in with
data from two bound fields (Start_Time, and End_Time) which are hidden on the
form. I did this so the dates are separate from the times allowing use of
the date picker for the dates and a spinner button for the times. As each of
the unbound fields is updated, the appropriate bound field gets updated as
well.

I've setup a conditional format on each of the unbound fields which is set
to evaluate the expression ([Start_Time] > [End_Time) and if the expression
evaluates to True, those 4 textboxes are supposed to change their background
to red and font to bold white. However, what is happening is that only the
control that has the focus when the change is made is actually changing its
formatting.

What am I doing wrong here, or are my expectations just too high?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top