Results 1 to 11 of 11
  1. #1
    ryp is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    11

    How do I hide this part of a subform?


    I apologize, I have tried to search this, but I just didn't know exactly what to search. I have a subform, and I'm trying to hide the small column that has the star and/or pencil in it (see attached image--outlined in red). I thought that was the record selector, but making the record selector not visible doesn't seem to impact it. Maybe I'm not doing it in the right place, or maybe it's not possible to hide that. Any insights would be much appreciated!Click image for larger version. 

Name:	access_question.png 
Views:	10 
Size:	6.4 KB 
ID:	6513

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Set the RecordSelectors to NO in the SubForm.

  3. #3
    ryp is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    11
    I do have Record Selectors set to No for the subform--it's very weird. Any other suggestions?

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Nope. When you open the SubForm by itself, is this column visible?

  5. #5
    ryp is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    11
    Yes, when I open just the subform and nothing else, that column is visible. If I look at the properties there, the Record Selectors field still says No. I'm wondering if some other property setting overrides that, though I've never run into that before (but this is my first time using Access 2010--I've mainly used 97-2003).

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Something is not right. Have you done a Compact and Repair yet? How about *importing* your db into a fresh new db and see if the problem follows: http://www.btabdevelopment.com/ts/impnew

  7. #7
    ryp is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    11
    I just tried both of those things, and the same issue occurred in the new database. Oh well, I guess I'll just live with it. I appreciate your help. I did find this forum post that says you can't hide those in datasheet view, though I feel like I've done it successfully in previous Access versions. Also, it seems like setting Navigation Buttons to No has worked for some people, but not for me. Thank you again!

  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    AhHaa, DataSheet view. That might be a problem although you can set up a ContinuousForm view that looks like DataSheet view. I never use Datasheet view. Is there some feature of Datasheet view you need?

  9. #9
    ryp is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    11
    I have two bound controls on the form (drop down boxes), and it's saying I can't use a continuous form (it actually says "You can't view a form as a continuous form if it contains a subform, an ActiveX control, a bound chart or a Web browser element")--are my drop down boxes ActiveX controls? Also, I just feel like Datasheet view looks cleaner (except, of course, for the record selectors).

  10. #10
    ryp is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    11
    Quote Originally Posted by ryp View Post
    I have two bound controls on the form (drop down boxes), and it's saying I can't use a continuous form (it actually says "You can't view a form as a continuous form if it contains a subform, an ActiveX control, a bound chart or a Web browser element")--are my drop down boxes ActiveX controls? Also, I just feel like Datasheet view looks cleaner (except, of course, for the record selectors).
    Actually, my bad--I may have been trying to change the wrong form. I did get a continuous form to work, and it looks okay, but I think I'll just go with the Datasheet--seems to be cleaner to me. I'll read up on continuous forms though--never really thought about using them much, but it was cool to see another option. Thanks!

  11. #11
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I find I can control Continuous Forms tighter than Datasheet Forms.

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

Similar Threads

  1. Hide each control, control group or subform?
    By BRV in forum Programming
    Replies: 2
    Last Post: 12-09-2011, 09:36 AM
  2. Hide subform and clear the space left
    By blueraincoat in forum Forms
    Replies: 7
    Last Post: 03-24-2011, 09:35 PM
  3. WHERE as part of JOIN not after
    By thestappa in forum Queries
    Replies: 1
    Last Post: 05-14-2010, 10:52 AM
  4. Replies: 6
    Last Post: 06-03-2009, 02:01 PM
  5. how to hide the fields in subform
    By tinytree in forum Forms
    Replies: 3
    Last Post: 05-01-2009, 07: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