How to stop userform closing by clicking X

[chrisjames25]

HI

IN excel there was a way to stop a user closing a userform by clicking the X in the top right corner. IS there a way in access?

I want to restrict it so a userform can only be closed by clicking a button within the form that closes the form.

 

[plog]

Why not remove the X from the form all together?

Properties -> Format -> Close Button -> No

 

[chrisjames25]

Doh, perfect. Many thanks

 

[Pat Hartman]

PS - Access doesn't support UserForms. They are Excel and Word constructs. Access forms are different and are simply called "forms".