Require a Value for a Field or Control
In the Forms Designer, right-click the field or control, then click Properties.
In the Properties dialog box, on the Validation page, select the A value is required for this field check box.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.