Access VBA - Don't want form to close if null

[MushMouse]

If a user clicks the x in the upper right corner to close a form with a required field & the field is null, Access prints a message saying "You can't save this record at this time"

Is there any way to customize this message?

My table has required set to true, & an appropriate message.

I've tried using Form Before Update. But it seems to bypass this & displays the table required message & prints "You can't save this record at this time..." afterwards

When I use Form__Error I can eliminate the unwanted messages, but the form then closes before the user is given an opportunity to correct the problem. Is there a way to tell Form_Error to remain in the form, rather than continuing with the user's request, which in this case, is to close the form?

Any help would be much appreciated!!

Can't use point Form_Error at an error handling function? I think that's what I used to do. It's been a couple years though.

We'll see how long till vass sees this, he'll know.

[vass0922]

I can't remember, but you should be able to get rid of the X method to close a form.
Once you get rid of it, put a button specific to closing the form, and put necessary code to check if its NULL.

Not sure if it works in Access, but also try to create a procedure called

Public Sub FormName_Unload(cancel as integer)
If input = blank then
cancel = 1
end if
End Sub

If its like VB, this method will be called as the form closes.
If its set to cancel = 1 it will cancel the unload, you can then also include necessary error handling.

[MushMouse]

Unfortunately, the users want to close their form using the standard x in the upper right corner.

I tried the unload procedure, but the form still closed afterwards.

Any other suggestions?