Results 1 to 8 of 8
  1. #1
    gaker10 is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2014
    Posts
    262

    Hide split form datasheet expandable

    I currently have a split form that looks like this:



    Click image for larger version. 

Name:	Parts1.png 
Views:	9 
Size:	23.5 KB 
ID:	19948

    In my sub data sheet, I have expandable (+) items based on relationships in my tables. I whited out some info for privacy. How do I hide the expandable icons in my split form? Is there a setting for it?

  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,770
    Check out the form SubdatasheetExpanded property.
    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
    gaker10 is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2014
    Posts
    262
    I did. It is set to no, which means the sub data sheets are just simply not shown automatically. If I set it to Yes, it shows the expanded sub data sheet. I don't just want to not expand the subdatasheet, I want the (+) option to not be there.

  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,770
    Interesting, I get the + when I open table but not in form bound to table. This form is in frontend. I don't have relationships set in the frontend. So I went to backend where I do have relationships. I created form on the same table and this one does show the +.

    I tried setting this form to Continuous View but won't let me because of subdatasheet.

    The form in frontend can be set to Continuous View.
    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.

  5. #5
    gaker10 is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2014
    Posts
    262
    I cant set front end form to Continuous View because of sub data sheet. I cant delete the relationship because it is inherited.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Not sure what you mean by inherited.

    I am able to set my frontend form to Continuous View.

    Oh wait, just hit me - split form. I never use.
    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.

  7. #7
    gaker10 is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2014
    Posts
    262
    That's the wording of the error.

    The users of this database are accustomed to split forms.

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Sorry, then the only solution I can see is to not set Relationships.
    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. Split form Datasheet Sort from A to Z
    By data808 in forum Forms
    Replies: 3
    Last Post: 03-30-2014, 12:43 AM
  2. Split Form with Datasheet on bottom
    By data808 in forum Queries
    Replies: 6
    Last Post: 02-19-2014, 03:05 PM
  3. Replies: 3
    Last Post: 05-02-2012, 10:13 AM
  4. Datasheet view of Split Form in a Tab??
    By tylerg11 in forum Forms
    Replies: 3
    Last Post: 12-19-2011, 04:37 PM
  5. Replies: 1
    Last Post: 05-23-2011, 07:11 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