Conditional Formatting Question

[Capilano]

I have a Continuous Form. The first Control on the Form receives the focus upon opening the Form. This Control has Conditional Formatting such that the Fore and Background colors change from the default colors when the Control receives the focus.

The Problem...

For a couple of seconds each time the User clicks on any one of the records, the first record in the list as well as the record that has been 'clicked' BOTH display the Conditional Formating. If the list is long, then the problem is less apparant because the user typically does not see that the first record also has conditional formatting. However, if the value that has been selected is near the top of the list, then for that first few seconds, both change color. This can be confusing for the user.

Is there anyway to correct this problem?

 

[Lyn Mac]

I'm curious. Can you pls. describe how you setup your conditional formatting. I do use this feature but I haven't had this problem.

Lyn

 

[Capilano]

Hi. First, I have a main form with a subform in the continuous form mode. Several fields are laid out in tabular formation on the subform. This means that the user can scroll through many records in the subform while still on the main form. At this point, everything looks/performs wonderfully.

However, once the subform receives focus, the first field - in this case Control1 - also receives focus. This prompts the first field of the 1st record to show the conditional formatting. Now suppose that I take my mouse pointer and 'click' on the 3RD record. For a brief period (maybe 1-2 seconds), the conditional formatting is displayed not only in the first field of the 3rd record but ALSO the original first field of the 1st record.

This is not a big issue, if I have scrolled down far enough in the subform to a point where the 1st record is out of sight. Then, when I click on any record at this point, the 1st record is out of sight and the user is not confused. The confusion is caused because for a brief period, the user really is not certain which record he/she has 'clicked' on.

I will keep the dialogue of this issue on the Access Form but I will e-mail you picture of what this looks like.

Thanks

Pat

 

[Lyn Mac]

You seem to have some VBA code in the controls. I have read that when you set conditional formatting of text or combo boxes in a continous forms the formatting of the controls on the first record will be propagated to other controls in the other records regardles of the value of the controls.

In A2k there is a feature called Conditional Formatting (which uses no coding) from the Format menu where you cant set up to 3 conditions to format. To use could with this feature you may the use the FormatConditions property of the textbox or combo box controls.

Lyn