change fields border color on a continuous form 1

[welshone]

hello all,

I have created a subform on a form.
The subform default view is set to continuous forms,
how can I change a field's border color when I change a combo boxs value on the same continous form.

eg,
If cmbstatus = 1 then
change txtboxName's border color to red but only for the selected row on the continuous form
else
border color = black
end if


thank you for any help.
W

 

[mgolla]

You should look into Conditional formatting to accomplish this task.

Select the textbox on the continuous form and then from the Format menu choose Conditional Formatting

Access help has some info about it.

HTH
Mike

 

[welshone]

thanks Mike thats great.

 

[welshone]

problem with this is I can only add 3 formats !
what can I do if I want greater than 3 different formats for my continuous form ?