Solved The form size fits my screen (1 Viewer)

[lacampeona]

Hello experts,
I make all my forms to fit my screen. I am using laptop and I want that all my forms be the same.


In my work I have big screen I do not want that my forms change becouse then my ms app is not " so nice".
How to do that?
I know that exist some properties on form properties :What I have to set correctly?
Thanks in advance

 

[CJ_London]

What do you mean by

I do not want that my forms change

You mean you don’t want it to fit the screen? Something else?

perhaps you are using layouts? Although I see you are viewing as datasheet

 

[lacampeona]

Hi

You mean you don’t want it to fit the screen? Something else?

I mean I want that my form is the same size like in my "small" screen and also the same size when opening the same form on "big"screen.

Now is happening that on my laptop all is nice and when going to big screen everthying gets smaller and streched.

Yes I have also forms in datasheet view.

 

[CJ_London]

Should also have asked if this is a popup form or you are using overlapping windows - I'm assuming yes.

If I've understood you correctly you will need to determine the size you actually want by dragging the borders then saving the form.

I believe the auto resize property doesn't apply to datasheet forms and the fittoscreen is about reducing the form for smaller screens so no harm in setting these properties to No

So might be worth resizing the form on your big screen, then save.

I can't think of a single instance where I open a datasheet form directly - they are all subforms on a single form. So another thing to try is putting your form on a main form as a subform, sizing the new form as required leaving the subform at the required size

 

[lacampeona]

Hi

Should also have asked if this is a popup form or you are using overlapping windows - I'm assuming yes.

I dont use pop up. I am using form and subform.
Yes my subforms are in datasheet view.

o another thing to try is putting your form on a main form as a subform, sizing the new form as required leaving the subform at the required size

Yes I just start work in that way...it will take time to have all forms perfect
thank you for your suggestion

 

[CJ_London]

so it is really about the size of the subform, not the form? You haven't said whether you are using overlapping windows or not (alternative is tabbed windows)

Check you not are not using the anchoring feature for the subform control or have code in the main form resize event to modify the size of the subform

 

[lacampeona]

Hi
yes I am using tabbed windows.
I checked my codes I am not using no resize event to modify the size of the subform.
I now prepare all my subforms to fit in the main form window....

 

[isladogs]

Intriguing that you want to keep all forms exactly the same size no matter what the screen size is

I would suggest you consider the complete opposite whereby all forms and their contents are automatically resized in proportion to the screen size & resolution. This works for all types of form including datasheets
Automatic Form Resizing - 1 (isladogs.co.uk)

 

[lacampeona]

Hi Isladogs
I have

so with that magic code my form will became "perfect" also in another screens?
So I have to put on every form?

Private Sub Form_Load()
ReSizeForm Me
end sub

Ok I will try it
thank you

 

[isladogs]

That's the bare minimum you need to do.
Additional code is needed for:

• datasheet forms
• form zoom
• form stretch/shrink feature

Have a look at the presentation PDF and then you need to study all my articles carefully before converting your app.
If you just dive in and expect it to work perfectly first time, you may well be disappointed.

And of course, make a BACKUP first

 

[lacampeona]

Hi
Yes I understand.
Yes I always make backup.
Thank you