How to reduce the size of Login Form!

[cap.zadi]

Hey there,



IS some one can help me out to reduce the size of login form and it should appear in small size?

thanks

zee

[goodguy]

Please elaborate what you mean.
The form will appear in the same size that you designed it with. Is this not happening?
You can also look at the Format properties of the form: Autocenter, Autoresize, FitToScreen, etc.
Lastly, you can set the exact height and width of the form in code in the form's load event

[cap.zadi]

well, yes thats what i am looking for and have try many times:Autocenter, Autoresixe and fit toscreen but it same apear in fullwindow but i like if the loging form can be just in small window when i open access db. yes it hink that can work but need the codes? can you advise please?

thanks man.

[goodguy]

Does this affect one form only or is it across all forms and databases?

[rpeare]

It's probably because you have your window maximized, access will inherit the maximized feature from any form if you have it open. To get it to the size you have designed it you would have to run something like

docmd.restore in the ON OPEN event of the form

[kennejd]

You could set the popup, modal properties of the login form. That's how the login form would normally appear, I think.

[cap.zadi]

ok thanks guys. let me try and will revert you.

[cap.zadi]

hey guys, its really working fantastic.

i just put on even

cmd.Restore

and click yes for popUp and Modal properties.

thanks a lot.