Default message for a required field when it isn't filled

[Bresart]

Hi, in the table in which a form is based, there are some required fields, which if aren't filled, the default message is

"The field 'tblName.fieldName' can't content a Null value because..".

Would be to change 'tblName.fieldName' for other text possible (introducing text in the title property of the field hasn't worked)? Or better, to change the default message for an established one?

To set the fields Required property to No and making a code handling isn't suitable in this case.

Thanks for any help given.

 

[fneily]

If you do a search on this forum, you'll see answers for this, such as:
thread702-1407840

See TheAceMan1 first post with code.

 

[TheAceMan1]

How are ya Bresart . . .

In the Tag property of the textboxes of interest enter a question mark ? (no quotations please). Then in the Before Update event of the form, copy/paste the following code from my post at the bottom of this thread: thread702-1389812

See Ya! . . . . . .

Be sure to see thread181-473997

 

[Bresart]

Thanks fneily TheAceMan1.