Field Properties Through Conditional Statement
-
- StarLounger
- Posts: 76
- Joined: 14 Jul 2010, 19:35
Field Properties Through Conditional Statement
I am looking to set up a on update command on a field. They can chose one of 5 options, 2 of which requires dates involved. I'd like to enable the date fields for editing when those options are chosen, and make them required fields. And when the other 3 options are chosen I'd like the dates to clear out and no longer be enabled. Just wanted to know if this is possible. I've been searching through the SQL code but couldn't find these properties to set.
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Field Properties Through Conditional Statement
You can only do this in a form, not in a table.
Check out the Enabled, Locked and Visible properties of the text box control.
Check out the Enabled, Locked and Visible properties of the text box control.
Best wishes,
Hans
Hans