Required Field Validation

[Gerilee]

In the Before Update property of my form, I am using With and For Each along with Case and a value in the Tag property to validate all of the required fields on my form. I've got it working to display the control name/field name in the error message by using the Name property. This displays the name of the control/field. I would like to use the Caption of the control's associated label from the form to make it a more user-friendly message. I've tried to put 2 values in the Tag property separated by a semicolon and reference it as Tag(1) but I just can't seem to get it. Also, I need to make the default Access message stop showing after my custom message displays. Thanks for any help.

 

[PHV]

the Caption of the control's associated label
ctl.Controls(0).Caption

Use Cancel=True and Exit Sub

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886