change textcolor when data changes

[aymanmb]

I have a datasheet form that is lnked to order details table. this form is displayed as a subform in the main oder form.

in this datasheet, there is a field names "Completed" to inidcate that this part of the order was executed.

I want to change the color of all lnked field to this completed item to change to blue for example when the user check the "Completed" field.

can it be done

 

[ansentry]

Look up "Conditional Formatting" in help.

Please try and help your self first, however if you still have a problem then post back and I will post a sample for you.