Disable form minimizing

[garyd1234]

Hi,
I have a form that I want to load based on who is logged in. I want to make it so they cannot minimize it and see what is behind it. I have security set up so they cannot get into tables, forms, etc but it would be great if they also couldn't see behind the form. I maximize the form and set its Popup and modal to yes and Borderstyle to dialog. This takes away the max, min, and close buttons but, if the user double clicks on the border it still makes the form about half size and they can still drag it around. How do I stop this in code so administrators will have the min, max etc. but certain log in people will not?

Thanks

 

[icusawme]

Hi,
I couldn't replicate the double clicking of the border to resize, once the form was maximized the entire window reacted to the resize on border double click. I still couldn't see into the database window (behind the open form).
To change these properties on the fly put the following in the form code
The built in help has more info on the different settings
Private Sub Form_Open(Cancel As Integer)
Me.BorderStyle = 1 'Sets border to thin and is not resizable
Me.AutoCenter = True
Me.AutoResize = False
Me.PopUp = True ' popup keeps it on top
Me.MinMaxButtons = 0 ' the Min Max buttons are not visible with this setting
End Sub