What if I want the form always maximized without a border?
Try setting the Border Style property to None.
Currently have maximize command in the forms code, and the restore button
always appears even if the min/max is set to none.
Are you talking about the min/max buttons for the Access window? If you are,
I would not recommend trying to get rid of this, because that can limit how
people use their computers with other applications running at the same time.
If they cannot minimize your application, in order to do some other task,
they likely won't be too happy with you. I certainly do not see any restore
button for the *form* when the min/max property is set to None.
I can deal with the form if there is no way arround this, but then how can I
keep the forms from cascading as I open them (i.e. hide each form as a new
one is open
You can use code to hide the current form (Me.Hidden = True), or you can
close the current form in the code used to open a new form. If you want, you
can even get fancy with some VBA code so that the new form that is opened
"knows it's daddy" so-to-speak. In other words, with some relatively simple
VBA code, you can have the situation where:
Form A ---> Can open Form C
Form B ---> Can also open Form C
Now, when you close Form C, the form that the user was previously on, either
Form A or Form B, is automatically re-opened for them.
Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________