Okay gentlemen. I am going to have to plead ignorance. I only see the "Size to fit" when I choose "Layout view" and it selects the first field in the form. (happens to be a date field). I only get the option to select "Size to Fit" when I choose one field from the form. If I choose the form itself nothing happens. I can no longer select "Size to Fit" at that point.

I looked for the Form_Load event. I do not see it anywhere.

I am not sure how to embed the code in the VB from here either. I am green as can be. If you can get me into the right section or area that the code should be in I think I can put this together. Any thoughts on that?

if can upload a copy of the db, i can take a look at it.

did you try my recommendations?

Yes,

Please reply to each Experts suggestions in order.
It is not clear if you tried my suggestion either...

JeffCoachman

SizeToFitForm seems to work on controls, but not on the form.  It wasn't even available in design view.  It only became enabled when I changed to Form View.

seen my comment here http:#a33727359 ?

fyed: I did try your suggestions exactly. They did not work. Sorry.
Boag: I tried yours as well. All of your suggestions I tried and that did not do it either.
capricorn1: Is it possible to upload just the form or do I have to upload the whole db. That will be a bit harder. The data in there is unique and I cannot post that. It is unfortunately sensitive.

just create a blank db, import the form and the table, delete the contents of the table..

upload the created db...

Don't ask me how but I looked at it a few days ago and the Form Footer was about 4 - 5 inches long with nothing in it I shrunk it down 3 days ago and thought that it saved. I went back today and saw there was space still there. I shrunk it a second time and it seemed to hold. The problem went away. I thought I had tried that fix and thought it did not take. Thinking I did the wrong thing I went to you guys. All your answers are clearly supportive to the solution in one form or the other but the fix seems to have been collapse the form footer and it goes away; I swear I tried that one. Oh well. Sorry gentlemen. Very sorry. I can still give credit for effort can't I ?

Collapsing the form footer worked.

Size to Fit Form is a command (on the toolbar or the Ribbon, depending on Access version) in the interface only.  Here is a screen shot of it as a menu item in Access 2003.
Size-to-Fit-Form.jpg

For the Load event, in design view open the form's properties sheet, select the Events tab, and select [Event Procedure], then enter the code into the code stub.  Here is a typical Load event.

Private Sub Form_Load()
'Created by Helen Feddema 2-Jul-2006
'Last modified 9-Jul-2006

On Error Resume Next

   DoCmd.RunCommand acCmdSizeToFitForm

On Error GoTo ErrorHandler
   
   'Load textbox values from db properties
   strDocsPath = GetProperty("DocsPath", "")
   Me![txtDocsPath].Value = strDocsPath
   strTemplatesPath = GetProperty("TemplatesPath", "")
   Me![txtTemplatesPath].Value = strTemplatesPath
   strFolderPath = GetProperty("FolderPath", "")
   Me![txtOutlookFolder].Value = strFolderPath
   
ErrorHandlerExit:
   Exit Sub

ErrorHandler:
   MsgBox "Error No: " & Err.Number & "; Description: " & _
      Err.Description
   Resume ErrorHandlerExit

End Sub

Select allOpen in new window

The reason for putting On Error Resume Next in front of the SizeToFitForm command is that if you step through the code, it will generate an error (since this command only works in form view).  So I wait until after running that command to place the On Error GoTo ErrorHandler statement.