Form don't have to be maximized !! 1

[TorF]

My form is configured to always keep the same size.
Normaly it's impossible to minimmize, maximize or resize the form.
(Border Style=Thin ; Control Box = Thin ; Min Max Buttons = None ; Close Button = No)
That works correctly.

However, if I maximize the 'database window' (the window that contains the table, queries...) and then i open my form, the form is maximized.
This is the result that I don't want for my form...

Is there any solution to resolve this 'malfunction' ??

 

[kmw]

Presumably though, when you give the db to the users, you will be hiding the db window? This wont affect your form then.

 

[TorF]

Thanks, that is a solution.

But I will not hide the db window.

Is there any others solutions ?

 

[Betsvigi9]

Changing the forms popup property to yes, will stop the form from maximising.

 

[TorF]

YES !

That works fine

Thanks

 

[TorF]

I find another solution, if you don't want to set the form popup property to yes :

Private Sub Form_Load() 'or open surely
DoCmd.Restore
End Sub

 

[SequenceIT]

I second the last post! I always use DoCmd.Restore on form load for consistency, and set the Form's AutoResize and AutoCentre so they always turn up in a predictable location. All the stuff you read about user interface design aside, I've had users thank me for designing forms this way - they always know what to expect. Andrew Webster MCSD

Sequence Information Technology