Not for Tables and Queries. For forms, size the form to the size you want. Save it, it will retain that size.

one more stop on your database go to your property sheet and look to see if you have auto resize in the format tab.
you have auto center, auto resize, fit to screen.  you may like to play with the setting to get the desired output.  Give it a shot and let us know if this worked or not. I like to get the feedback.

I wrote a VBA Class tat your forms can use so if your user changes the forms size or location on screen, the form will automatically restore that size and position the next time it's opened.   Using the class is very simple, just download the source code from:

Github at https://github.com/NfaToys/Access-VBA-Classes

then add the following code snippet to each form that uses the class module.

' To use this class set your Form "Border Style" to "Sizable" and "Min Max Buttons" to "None"
' this code does NOT include support to restore a Form to a Maximized or Minimized state.
'
Option Compare Database
Option Explicit
'
''  place this at the top of the Forms code module
Private sl As New SizeAndLocation
'
''  place this in the Forms Open Event
Private Sub Form_Open(Cancel As Integer)
   Set sl.MyForm = Me.Form
End Sub
'
''  place this in the Forms Unload Event
Private Sub Form_Unload(Cancel As Integer)
   sl.Save
   Set sl = Nothing
End Sub

Thanks for the comments.  Only the Form Properties have auto resize and format properties.  Changing those did help for the forms.  However, you are correct about the tables and Queries.  Thanks