Resizing Access Window to fit the size of the Form inside window (1 Viewer)

[JDW56]

Hello Everyone,

Trying to manage the sizing of the main Access Window to auto adjust to the sizing of my forms.
I only want the login form window displayed, not the FAIR Tracker window; or find a way for the FAIR tracker window to automatically adjust to the size of the form being displayed.
If more details are needed, just lmk and I'll provide them. Cannot figure this out for the life of me.

 

[tvanstiphout]

There is a way to do this if you make your form a popup (so it can live outside the Access main window), and then resize the main window behind it. Search for it online. Takes several Windows API calls, but it is possible.

If that is the biggest problem in your app, you're doing pretty well.

 

[The_Doc_Man]

The base command for this is Application.DoCmd.MoveSize() where you supply the position and size of the window. Here's the call reference.

DoCmd.MoveSize method (Access)

Office VBA reference topic

learn.microsoft.com

 

[tvanstiphout]

The base command for this is Application.DoCmd.MoveSize() where you supply the position and size of the window. Here's the call reference.

DoCmd.MoveSize method (Access)

Office VBA reference topic

learn.microsoft.com

There is a tad more to it than that, considering the user can move the login form, and the main window needs to remain underneath.

 

[DickyP]

I personally launch Access live database FEs to run minimised then all you see is the forms, even if the user moves the form. The forms do need to be pop-up, or at least the Start-up form needs to be. see below for an example.