Prevent resizing of a form 1

[pbrown77]

When the form opens (max/min buttons = none), (close button = no), (control box = no), so instead of 3 icons appearing for the form (_, box-in-a-box ([)], X) only the ([)] appears (along with a dialog box that says "Type a question here for help".

Is there away to prevent the ([)] from appearing. Even though I have unchecked the display.. and they can not change anything, I would prefer if they can not resize the form and move it over the screen (more of a "this is not for play, but for work request) You would not believe the number of people who sit there and just move it around for 15 or 20 min. Or just like to see what they can break.

I have set the "Border Style" to each type and none work. The only thing they do is change the border once the user clicks the ([)].

Also, is there away to remove "Type a question..."?

 

[ssatech]

Pbrown,
Why don't you just remove the command bar menu. This way you hide ([)] and "Type a question..."?

Put this code On Open Event of your form.

Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i

 

[pbrown77]

THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!

This is a question I have asked at several "Microsoft" groups at microsoft.com, but never received an answer that works!


You have no idea how much this helps, and it appears from your post you knew the answer "off the top of your head"

 

[ssatech]

Your welcome,

Another method you could employ is hiding the Access Window.
This way you just show your form without the Access Window.
This would only work if all you commands are driven from your forms and not utilizing a built-in menu.

Food for thought......

 

[pbrown77]

That may be the problem I found.
The form opens great, but now the custom bar is gone. So the users can not use the bar(print, close, e-mail) when the reports open.
Also, since I have disabled the ablity to exit access unless they go to the form and click "exit" there is no easy way to close the DB.

Any ideas on how to have the custom bar but no ([]) or "Type..."?

 

[pbrown77]

I thought of driving everything from forms, but how would a person open a report then print? (sometimes users just need to view not print the report)

Also, when the report opens and then closes the main form does not come back maximized. I have tried
Docmd.maximize
on the On Open, On Activate, On Got Focus

but it just is not doing it.