Hello,
I have a form where the user hits some buttons to manipulate and clean data in a table. Then, the user needs to have access to the entire table in datasheet view to spot check things and manually make any necessary changes to one field (the rest of the fields are locked). What I need to do is make the Comments field required- they have to fill in an explanatory note if they make any manual changes. In the underlying table, I set the Required property of the Comments field to Required and in the form, I set the Validation Rule property to Is Not Null and put in some validation text.
But this isn't doing the job. I can enter any change I want and move to any other record and the form isn't stopping me- even when I close it out.
What is the correct way of making this field required? What I want to be able to do is make it required before closing out the form, but also before moving to another record.
Thanks in advance for your suggestions.
(Access 2003)
I have a form where the user hits some buttons to manipulate and clean data in a table. Then, the user needs to have access to the entire table in datasheet view to spot check things and manually make any necessary changes to one field (the rest of the fields are locked). What I need to do is make the Comments field required- they have to fill in an explanatory note if they make any manual changes. In the underlying table, I set the Required property of the Comments field to Required and in the form, I set the Validation Rule property to Is Not Null and put in some validation text.
But this isn't doing the job. I can enter any change I want and move to any other record and the form isn't stopping me- even when I close it out.
What is the correct way of making this field required? What I want to be able to do is make it required before closing out the form, but also before moving to another record.
Thanks in advance for your suggestions.
(Access 2003)