Results 1 to 8 of 8
  1. #1
    MrDummy is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Sep 2015
    Posts
    50

    Left hand grey squares in the Datasheet

    Hello ,

    In a mainform I have a subform as DataSheet. On the left there are these grey squares for each record. Is there a way to remove these or to minimize the width.



    See attachement
    Attached Thumbnails Attached Thumbnails search-results-700.jpg  

  2. #2
    cyanidem's Avatar
    cyanidem is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2015
    Location
    Consett, UK
    Posts
    270
    Set Record Selectors property for that subform to No

  3. #3
    MrDummy is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Sep 2015
    Posts
    50
    Hello,

    Sorry fort he late reply. However this does quite do what I expected it to do. The record Selectors at the bottom are gone now but the squares on the left are still there. Tried some other settings but unfortunately no luck.

  4. #4
    cyanidem's Avatar
    cyanidem is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2015
    Location
    Consett, UK
    Posts
    270
    Hmm, unless MS swapped names for this two elements in A2013 (I use A2010) - those "grey squares" are Record Selectors, and things you call "record selectors at the bottom" are Navigation Buttons. They're next to each other in property sheet so maybe you switched off wrong one by mistake?

  5. #5
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,614
    I think you will find that the Record Selector property setting has no effect when the form is show in datasheet view. However, you could hide them if you made the form a continuous form which could be designed to look like a datasheet form.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  6. #6
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Bob's right...that's your only option, given what you want to do.

    Just out of curiosity...why do you want to get rid of this component?

    Linq ;0)>

  7. #7
    cyanidem's Avatar
    cyanidem is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2015
    Location
    Consett, UK
    Posts
    270
    Quote Originally Posted by Bob Fitz View Post
    I think you will find that the Record Selector property setting has no effect when the form is show in datasheet view.
    That's a new one for me, probably due to never using datasheet view. I always use single or continuous form and design it to my needs.
    Anyway, TIL

  8. #8
    MrDummy is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Sep 2015
    Posts
    50
    Many thanks for the effort and the replies. It is more visually that I don't like it. I will go ahead with the Continious form then

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

Similar Threads

  1. Replies: 1
    Last Post: 04-29-2013, 02:16 PM
  2. Transparent Squares on Forms
    By ges12 in forum Forms
    Replies: 1
    Last Post: 11-08-2012, 02:50 AM
  3. Left Hand column in chart empty
    By Kirsti in forum Reports
    Replies: 10
    Last Post: 03-20-2012, 01:41 PM
  4. Replies: 3
    Last Post: 02-02-2011, 01:00 PM
  5. Hard Returns v. Squares
    By Goodge12 in forum Queries
    Replies: 3
    Last Post: 01-28-2009, 10:10 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