Results 1 to 9 of 9
  1. #1
    eabreunig is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2016
    Posts
    8

    Split Form Doesn't Show All Fields

    I have a split form 'fFixtures', for which the record source is table 'tFixtures'. In Form view, the datasheet portion does not show all the fields that exist on the actual 'tFixtures' table. I can right click and say 'unhide fields', but the fields I'm missing do not appear on the list. Any ideas what I might be missing? Thanks in advance!

  2. #2
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Do you have the columns in the original table tFixtures hidden?


    Sent from my iPhone using Tapatalk

  3. #3
    eabreunig is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2016
    Posts
    8
    No, they are not hidden in the original table.

  4. #4
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Are any of the column widths set to zero? In design or in code.


    Sent from my iPhone using Tapatalk

  5. #5
    eabreunig is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2016
    Posts
    8
    andy49,

    Forgive my ignorance on the subject, but could you tell me where I might find this information? Should I be looking at the table's design and code, or the form's?

  6. #6
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Can we see a screenshot please


    Sent from my iPhone using Tapatalk

  7. #7
    eabreunig is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2016
    Posts
    8
    Sorry for the delay. I'm back at this task now. Please let me know if I ought to screenshot anything else Click image for larger version. 

Name:	Fixtures Split Form.jpg 
Views:	19 
Size:	152.7 KB 
ID:	26921Click image for larger version. 

Name:	Fixtures Table Design View.jpg 
Views:	19 
Size:	174.5 KB 
ID:	26922Click image for larger version. 

Name:	Fixtures Table.jpg 
Views:	18 
Size:	237.7 KB 
ID:	26923

  8. #8
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Can I have a screen print of the design of the form ?


    Sent from my iPhone using Tapatalk

  9. #9
    Accessible is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2011
    Posts
    4
    Quote Originally Posted by eabreunig View Post
    No, they are not hidden in the original table.
    Chances are that in the split form datasheet, instead of right-clicking and hitting Hide, you right-clicked and hit Delete.

    In any case, follow the procedure for adding an existing field to a form:

    1. Put the form in Layout view.
    2. In the Design tab, locate the Tools group on the right side of the Ribbon.
    3. Click the Add Existing Fields command.
    4. The Field List pane will appear. Select the field or fields to add to your form.
    5. The new field will be added.

    When I did this, I dragged the field to a blank "field space" in the datasheet, and couldn't put it there. So I dragged it to the space of the last field. It accepted the field there (putting it at the end), and also put it at an arbitrary position in the main form.

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

Similar Threads

  1. Replies: 3
    Last Post: 01-31-2014, 09:13 AM
  2. Replies: 8
    Last Post: 01-20-2012, 05:07 PM
  3. Replies: 1
    Last Post: 12-21-2011, 02:04 PM
  4. Replies: 3
    Last Post: 08-23-2011, 04:35 PM
  5. Replies: 1
    Last Post: 07-12-2009, 05: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