Unanswered: Highlight current field when have multi sub forms
I have multiple (Continuous Forms) sub forms on one main form
I'm using on got focus = clolorYellow([myfield])
on lost focus = clolorWhite([myfield])
Then public function clolorYellow(fieldname as control)
Fieldname. backColor = 65535
One, this function select that column (not just that record.)
Two, when I go to the second sub form, the first form field stays highlighted, I guess the on lost focus doesn't work because that field also has the focus.
When a form is open in continuous or datasheet view, only the conditional formatting features can be used to change the appearance of a control based on some condition on an individual (i.e. row) base. Everything else will change the controls of the whole column.
When you use the conditional formatting features of a control, it's appearance does not change whether it has the focus or not. Only the condition(s) you specified in the conditional formatting window matters. If the conditions are the same in both subforms, the specified format will be applied to the control(s) in both subforms.