CODEWITHSUNDEEP
ms-accessvba
DarkW1nter
DarkW1nter

Reputation: 2851

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

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

Upvotes: 1

Views: 4713

Answers (1)

Fionnuala
Fionnuala

Reputation: 91376

You can use conditional formatting for continuous forms and datasheets.

enter image description here

Upvotes: 3

Related Questions