Properties Dialog Box

[PeterM]

I'm running Access 2003 as an Access 2000 file format.

I want to make certain forms modal, but unless I remember
to save the form with the Properties Dialog Box already
closed, that dialog box will display when the form is
opened and since the form is modal, I can't dismiss the
Properties Dialog Box. Is there a way to do it via VBA?

Please help...thank you!

 

[MacDermott]

Each form has an AllowDesignChanges property - one of the last on the
Property Sheet.
It defaults to All Views, but if you set it to DesignViewOnly, the property
sheet will never display when the form is in Form View.
I think that's all you need, but you can set this property programmatically
if you like.

HTH
- Turtle