Results 1 to 4 of 4

Thread: Form suddenly disappears

  1. #1
    Junior Member
    Join Date
    Dec 2012
    Posts
    12
    Rep Power
    0

    Form suddenly disappears

    I have an Access 2010 database with a form containing a tab-control. I've slowly been adding several stand-alone forms as pages on the tab-control. I just added 2 more, and all of a sudden the form does not display in Form mode. It doesn't even get to the Activate event.

    I removed the last two pages - the ones that I had just added, but the form is still non-operable.

    I've never seen this before and am stumped as to how to proceed. I'm getting ready to dump some basic data (numer & types of controls, etc) but in the meantime has anyone ever seen this before?

    Thanks,

    Tony

  2. #2
    Junior Member
    Join Date
    Dec 2012
    Posts
    12
    Rep Power
    0
    Some additional information.

    I can track the form's activity through the Load event, but then it never makes it to the Activate event. (This matches, as far as I can tell) the visual symptoms, where the form is seen to be available, but there is nothing there.

    I'm nowhere close to the limit on the number of controls:
    Summary report for form CCCBR (CCCBR Master form)
    CCCBR (CCCBR Master form) has 49 Text boxes
    CCCBR (CCCBR Master form) has 16 Check boxes
    CCCBR (CCCBR Master form) has 3 Combo boxes
    CCCBR (CCCBR Master form) has 16 Check boxes
    CCCBR (CCCBR Master form) has 13 Command Buttons
    CCCBR (CCCBR Master form) has 90 Labels
    CCCBR (CCCBR Master form) has 1 List boxes
    CCCBR (CCCBR Master form) has 9 Pages
    CCCBR (CCCBR Master form) has 0 Radio buttons
    CCCBR (CCCBR Master form) has 1 Tab controls
    CCCBR (CCCBR Master form) has 0 Toggle buttons

    The form consistently uses about 288/292 KB of memory when it is 'loaded', and releases most of it when it is closed. So, something is going on!

    Tony

  3. #3
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Do you think you can share this file without any PII or confidential data?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  4. #4
    Junior Member
    Join Date
    Dec 2012
    Posts
    12
    Rep Power
    0
    Thanks for the response. Another source discovered that I had somehow, inadvertently set the Visible attribute of the detail area to false. Access was simply doing what it thought I wanted! Now of course I have to re-program myself to avoid such egregious fat-fingering!

    Tony

Similar Threads

  1. Populate data in form
    By Ryan_Bernal in forum Excel Help
    Replies: 4
    Last Post: 02-01-2013, 10:18 AM
  2. Search form on work sheet
    By Ryan_Bernal in forum Excel Help
    Replies: 5
    Last Post: 01-15-2013, 11:46 AM
  3. Replies: 3
    Last Post: 12-07-2011, 09:59 PM
  4. Adding A Menu Bar To A User Form
    By Rasm in forum Excel Help
    Replies: 14
    Last Post: 05-05-2011, 04:05 AM
  5. Animation on Form Control
    By Mechanic in forum Excel Help
    Replies: 4
    Last Post: 03-22-2011, 08:56 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •