[AccessD] Forms too wide-able on wide monitor

[Stuart McLachlan]

Another alternative to stop users from messing with the form size:

Private Sub Form_Resize()
DoCmd.RunCommand acCmdSizeToFitForm
End Sub


On 19 Mar 2024 at 12:07, Stuart McLachlan wrote:

> You'll need to work out a suitable value,but: 
> 
> Private Sub Form_Resize()
> Me.Caption = Me.InsideWidth ' just to see what's going on
> If Me.InsideWidth > 10000 Then Me.InsideWidth = 10000   'twips
> End Sub
> 
> 
> 
> On 18 Mar 2024 at 21:46, Bill Benson wrote:
> 
> > Assuming possible (which is may not be) .... How can I put a governor in a
> > form´s resize or other event such that my form´s won´t stretch out too far
> > on user´s systems with super wide monitors? I think there is a recursive
> > artifact causing efforts to set the form to a specific width upon form
> > resize; maybe I am just supposed to lock down the min max buttons.
> > 
> > 
> > Been a long while since I did any MS Access development.
> > -- 
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>