Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20
  1. #16
    chalupabatman is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Aug 2016
    Posts
    114
    Quote Originally Posted by John_G View Post
    I cannot replicate that behaviour. Can you post a screenshot of those "empty white columns"

    In the sample database that I upload, if you open qryAllData subform and use the scroll bar to scroll to the right, do you not see the empty columns that are included?

  2. #17
    chalupabatman is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Aug 2016
    Posts
    114
    Quote Originally Posted by June7 View Post
    It's tricky. Have to size the columns and form so the horizontal scrollbar is not needed. Close the Datasheet form and it should reopen with the same setup. Set the BorderStyle to something other than Sizable so users can't drag the edges and expose the blanks.

    I can understand preference for a datasheet subform on a main form. I have one form with that setup. I also tried Continuous view but didn't like the way the record scrollbar worked. Lot's of buttons on the main form and the scrollbar extended up into the header area which is quite large on this form. However, the main form is UNBOUND.
    I just need to reduce column size (meaning width) on the sub form, then I will not receive teh blank spacing at the end?

  3. #18
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Still there, but without scrollbar and with the Sizable property set, users are less likely to reveal. Of course users are able to manually change width and order of columns in Datasheet view which can cause the blank area to reveal. Cannot do that with 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.

  4. #19
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    In the sample database that I upload, if you open qryAllData subform and use the scroll bar to scroll to the right, do you not see the empty columns that are included?
    No - I don't see any empty columns. The scrollbar can make the form move to the left so that most of it is off the screen leaving empty space, but that's not the same thing as empty columns. It also seems to be normal behaviour for all objects in datasheet view; I can replicate the same thing in tables, queries, and forms in datasheet view in my own database (as long as they are wider than the screen to begin with).

  5. #20
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    June7 has the answer for you in post #18. Open your form in form view, so that you see the subform in datasheet view. You can then resize the columns as rewuired, and the resizing will be retained. But you should also make your main form and the subform wider (in design view), so that you don't have to narrow the columns in the subform too much.

    Keep in mind though that user can resize columns too, so that the datasheet is wider than the form again, and it will put the scrollbar back.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Remove white space and empty fields and label
    By mathanraj76 in forum Reports
    Replies: 2
    Last Post: 01-10-2017, 04:02 AM
  2. need help on hiding empty space on report
    By nishant.dhruve in forum Access
    Replies: 2
    Last Post: 08-18-2016, 11:06 AM
  3. empty space start combo
    By sergran in forum Programming
    Replies: 30
    Last Post: 09-24-2013, 10:38 AM
  4. Replies: 1
    Last Post: 04-18-2012, 11:06 AM
  5. Getting Rid of Empty Space
    By Pam Buckner in forum Database Design
    Replies: 5
    Last Post: 03-05-2010, 05:46 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