Results 1 to 7 of 7
  1. #1
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904

    Strange Form Display

    Yesterday, I was creating a new Form, using an old Form as a template. Yesterday, everything looked good. When I went to open it Today, I got some On_Load errors. The only thing I have in the On_Load event is the command "DoCmd.Maximize". So I temporarily commented that out.



    However, now when I open the Form, it is displaying strangely. I have three sections: Form Header, Detail, and Form Footer. The length of all these sections is longer than the screen width, so the Detail section is only showing as much as it can. That, in and of itself, is not strange, I have lots of Forms like that. The odd thing is what it is showing in the Detail section. Instead of starting from the top of the Detail section and showing as much as possible with a scroll bar on the side, it is showing the very bottom of the Detail section, up as high as it can, with no scroll bar. So the top of my Detail section is being cut off, and I cannot scroll to it.

    I checked the Properties of both the Form and Detail section for anything odd, and could not find anything that looks out of the ordinary to me.
    Has anyone ever experienced anything like this, or know why this is happening any how to correct it?

    Thanks

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Any chance you can provide a sample of it?

  3. #3
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    I really wish that I could, but it is a very large, involved Access database with a SQL back-end and lots of confidential data.
    It would take a lot of time and effort to scrub it, reduce it down to size, and still have it functional.
    I was hoping that it is just some simple setting that someone may know something about.
    If I don't get a solution, I probably will just try re-building it from scratch.

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    I've had odd things happen to forms before usually when I'm directly copying the visual aspects of it but changing the record source. Is this what you did?

    if so don't copy the entire form create your new form on your new record source, then copy the objects from your old form to your new form (fields, buttons, etc) then open it and see what happens.

  5. #5
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    I've had odd things happen to forms before usually when I'm directly copying the visual aspects of it but changing the record source. Is this what you did?
    Yes.

    if so don't copy the entire form create your new form on your new record source, then copy the objects from your old form to your new form (fields, buttons, etc) then open it and see what happens.
    Thanks. I'll give that a shot.
    I would like to think that it follows some sort of logic and can be corrected if I just find the right Property. But I should know from experience that you can drive yourself crazy trying to fix these bugs and sometimes it is just easier to start over!

  6. #6
    mrojas is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2013
    Location
    Concord California
    Posts
    72
    Have you tried Compact and Repair?

  7. #7
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Have you tried Compact and Repair?
    Yes, that was one of the first things I tried (I've been around the block a time or two!)

    rpeare,
    I did what your recommended, and it worked! Thanks. I can now proceed and try to finish up this form.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Strange behaviour of MS Access form
    By selvakumar.arc in forum Forms
    Replies: 2
    Last Post: 08-15-2013, 12:07 AM
  2. Very strange issue: form opens blank
    By spleewars in forum Programming
    Replies: 5
    Last Post: 06-01-2012, 12:47 PM
  3. Replies: 9
    Last Post: 05-16-2012, 10:17 AM
  4. Strange missing data on form
    By AndycompanyZ in forum Forms
    Replies: 1
    Last Post: 06-27-2011, 05:45 AM
  5. Replies: 6
    Last Post: 03-17-2010, 10:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums