Please help - I do not know where I am going wrong with this. I have always just used vba to backcolor fields. This time I am using conditional formatting (new to it) and it is so simple. Just can't get it.
I have a form with 30 questions. Number field holds 3 values, yes 1, no 2, na 3. It needs to turn Green with yes, red with no, yellow with NA. Option group, radio buttons.
Is there a property to set the master order for these option groups? It seems like it almost has to go in tab order in order for the CF to behave. My users are going to pick and choose questions to answer - it can't go in sequential order. Question 10 has me stumped. Everything is there, but it will not backcolor. 11-14 work, but not ten. If I go back and work the options in sequential order, then 10 suddenly pops up and behaves.
Then there is a refresh issue. I may have too many controls on the page, but it seems to have a redraw problem. The form blanks out in spots after it calculates. This is the most complicated form I have done in a long time. I am just at a loss now.
Setup
Option group (SQ10F) 3 options. Transparent. Enabled, not locked. Underlying field is SQ10 (Number). After Update event - macro triggers save and then refresh. Tried the refresh to improve the redraw problem.
Unbound text box (tried it bound to SQ10 too, didn't change anything) SQ10C. Sits directly behind the option group. Formatting: Rule 1 Expression, [SQ10]=1 (Green), [SQ10]=2 (Red), [SQ10]=3 (Yellow).
That is all there is to it.
:banghead:
I would really appreciate any help or ideas. VBA a better idea?
I have a form with 30 questions. Number field holds 3 values, yes 1, no 2, na 3. It needs to turn Green with yes, red with no, yellow with NA. Option group, radio buttons.
Is there a property to set the master order for these option groups? It seems like it almost has to go in tab order in order for the CF to behave. My users are going to pick and choose questions to answer - it can't go in sequential order. Question 10 has me stumped. Everything is there, but it will not backcolor. 11-14 work, but not ten. If I go back and work the options in sequential order, then 10 suddenly pops up and behaves.
Then there is a refresh issue. I may have too many controls on the page, but it seems to have a redraw problem. The form blanks out in spots after it calculates. This is the most complicated form I have done in a long time. I am just at a loss now.
Setup
Option group (SQ10F) 3 options. Transparent. Enabled, not locked. Underlying field is SQ10 (Number). After Update event - macro triggers save and then refresh. Tried the refresh to improve the redraw problem.
Unbound text box (tried it bound to SQ10 too, didn't change anything) SQ10C. Sits directly behind the option group. Formatting: Rule 1 Expression, [SQ10]=1 (Green), [SQ10]=2 (Red), [SQ10]=3 (Yellow).
That is all there is to it.
:banghead:
I would really appreciate any help or ideas. VBA a better idea?