Preventing Form movement and sizing

[Transentient]

I have a database, I am looking for a way to lock the size and position of the form such the user cannot change it.

At present I currently have the forms borderstyle set to NONE. This achieves the result I require, but conflicts with another feature of my form.

On the form opening I use the Form Stretch/shinker module from Peter De Baets, to set the form size to the current screen size. However when the shrinker/stretcher module runs I get an error message, as the Borderstyle None prevents re-sizing

Additionally I have to keep the database as a MDB file as changing it would present other problems

Is there any way i can allow the shrinker/stretch module to run, but prevent the user from moving or manually re-sizing the form?

Many thanx

 

[wazz]

border style = thin prevents resizing but i don't know if it will conflict with the module.
there's also a form property called 'moveable' - it's in the 'all' tab at the verrrry bottom. set to no to prevent moving.

 

[Transentient]

Hi Wazz

Thanks for the info, i have looked for the "Movable" property before, I am using VBA in Access 97, I do not think this version includes this.

As to the module conflicting, I am doing some further tests

Thanx

 

[GolferGuy]

I have attached a database that has only one form in it. The form has borderstyle of None, but it can be Maximized which will cover the ENTIRE screen, because the form is a pop-up form. I have used it to blacken the whole screen. This form has no header, no close button (but if you press the "Esc" key the form will close. If the form was given a sizable border it could be sized and possitioned where ever you want it by using code. When you open this database, the form will resize itself to be a square on your desktop. Remember, no header, no close button, etc. You can put a box at the top of this form to make it appear to have a header if you want it to look that way. To close this form, just press the "Esc" key.