MS Access - conditionally set enabled or disabled for field in datasheet view

Question

I have a form with a subform in datasheet view, 2 fields Im working with are 'completed' and 'activity'. On the form open or load, how can I set 'activit'y for each line in the subform to enabled / disabled depending on whether 'completed' = Y or N? Any hint appreciated

thanks

Answer 1

You can use conditional formatting for continuous forms and datasheets.