Conditional Formatting based on other field values

[marnieg]

I have a tabular form where there are 5 editable fields. I want them to remain editable unless another field is set to a specific value. I'm assuming I can use the conditional formatting technique to handle this, but not sure how.

For example, one field is a number field they can enter, but if the field record_lock is set to on I don't want them to be able to edit the field.

Thanks,

 

[RuralGuy]

I would use code in the Current event of the form and the AfterUpdate event of the control in charge.

 

[missinglinq]

It's worth noting here, I think, that formatting the Locked and Enabled Properties is the only kind of Conditional Formatting that can be done using code, when dealing with Datasheet View or Continuous View (Tabular) forms.

Any other formatting of these types of forms can only be done with CF from the Format Menu.

 

[RuralGuy]

Good point Linq. I'm still pretty slow at remembering that Tabular forms and Datasheet View are the same thing.

 

[marnieg]

Could you possibly provide an example of how to code the CF or a link to a website that has some coding examples?

Thanks