Results 1 to 9 of 9
  1. #1
    CASmith is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    14

    Data not visible in Form view

    I'm sure it must be something simple, but all data in a Form in the detail section is visible in Design view but when I switch to Layout or Form view, it's blank.



    Thanks in advance for help!!

  2. #2
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Is the Data Entry property set to YES? It should be set to NO if you want to see records entered previously.

  3. #3
    CASmith is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    14
    Thanks for the reply. THe Data Entry was set to no. The Header and Footer show, just nothing in Detail. If I change the default background from white to a color, the entire panel is a solid color - as if it's in the foreground, hiding the labels and data fields.

  4. #4
    pg13Reader is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Sep 2011
    Posts
    13
    Look in the property sheet - Format section, near the bottom of the list is a "Display When" those items may be set to Print Only. Try changing this setting.

  5. #5
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    I just re-read your initial post and something confuses me. What do you mean by:

    Quote Originally Posted by CASmith
    ...but all data in a Form in the detail section is visible in Design view...
    How can data show in design view?

  6. #6
    SteveH2508 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2010
    Location
    Chelsea, London, England
    Posts
    117
    Does your recordsource for the form actually return any records?

    If it does not then this is classic behaviour for Access.

  7. #7
    CASmith is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    14
    I probably wasn't real clear in explaining, but when I'm in design view, everything looks normal - labels and fields are visible. When I go to Form or Layout view, only the Header and Footer are visible - the labels and fields are not. I have 3 records in the table and just noticed that in Form view it does not indicate any records are available. I created a new form using the Form Wizard and the form behaves properly - everything shows.

    I created the problem form in Form Design and once I had everything positioned, viewed it in Form View and this problem surfaced.

  8. #8
    CASmith is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    14
    pg13Reader - Display When is set to "Always"

    BobLarson - Good point. The field name and fields are visible. It looks like it should look until I switch to Form or Layout View, then everything in the "details" section of the form fails to show. If I drag a field to the Header and view it in Form view, it displays there.

  9. #9
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Well, it seems to be a bit of a mystery. Any chance you can upload a copy (with bogus data, of course) so we can look further?

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

Similar Threads

  1. View Data based on Form Input?
    By 0REDSOX7 in forum Forms
    Replies: 7
    Last Post: 11-29-2011, 10:25 AM
  2. Replies: 2
    Last Post: 01-06-2011, 04:38 AM
  3. Query results visible in a form view in Access
    By pawelek022 in forum Forms
    Replies: 0
    Last Post: 11-30-2010, 01:25 PM
  4. Replies: 9
    Last Post: 02-19-2010, 12:07 PM
  5. Replies: 9
    Last Post: 03-24-2009, 09:19 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