Results 1 to 4 of 4
  1. #1
    nbdwt73 is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Nov 2009
    Location
    Charlotte NC
    Posts
    12

    Field List window displayed in Form View


    I have a form with a subform that has started a strange behavior... Periodically (no apparent pattern) whenever I leave the form (go to next record, print report, send an email...) the field list (Add Existing Field) box pops up. I always thought that those boxes (property sheet included) displayed or were hidden based on the state the last time it was used in Design View. I have confirmed that all forms and subforms do not have the boxes in display state in Design View.

    I can go into Design View, close the box and all is well for awhile. It seems to happen more frequently when I go to print a report based on the data on the current form. My question is - what causes the Field List or Property Sheet to toggle on/off and can I suppress it either on a form or in the VBA code?

    I should also say that the system works flawlessly - this is more of an annoyance. I am sure it has been cause by some fat finger of mine - this started about 2 weeks ago in a system that has run for over a year.

    Thanks for any help...

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Never experienced that. Have you run Compact & Repair?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    nbdwt73 is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Nov 2009
    Location
    Charlotte NC
    Posts
    12
    Yes, that was one of the first things that I did... I have narrowed it down more... It is only the Field List box that is a problem. The properties box will "honor" the state. Once the field box appears, I have to go to design view, close it, then back to form view to remove it. It will stay that way for a few minutes of use.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    It is only the one form/subform this occurs with? Not other forms, not in other db files? Only thing comes to mind is form corruption. Can try to rebuild.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 3
    Last Post: 07-16-2013, 03:22 PM
  2. Replies: 10
    Last Post: 01-29-2013, 08:59 AM
  3. Replies: 1
    Last Post: 07-13-2012, 08:50 AM
  4. Replies: 2
    Last Post: 05-16-2012, 10:52 AM
  5. Replies: 5
    Last Post: 10-18-2010, 04: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
  •  
Other Forums: Microsoft Office Forums