Results 1 to 4 of 4
  1. #1
    Rawb is offline Expert
    Windows XP Access 2000
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875

    Forcing a Report to Expand Horizontally

    Hey everybody!



    I'm working on a Report that I'd like to expand to the right as it iterates through the Records. Is there a simple way to do this?

    Example:
    Code:
                              Header (big font and centered!)
                             ---------------------------------
    Record 1           Record 2           Record 3           Record 4           Record 5
    Record 6           Record 7           Record 8           Record 9           Record 10
    Record 11          Record 12          Record 13          Record 14          Record 15
    Record 16          Record 17          Record 18. . .
    I've figured out a way to get this effect, but it's going to be a pain in the tush to implement. I'm hoping for an easier way (like clicking some hidden "Expand Horizontally" button somewhere).

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    What you've pictured there could be achieved using the Columns tab in Page Setup. Does that work for you?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Rawb is offline Expert
    Windows XP Access 2000
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    You, sir. . .

    Are a genius!

    Thanks!

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    No problemo, but the number of people who would argue with you about the "genius" tag would fill a World Cup stadium.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Expand entire row not just single cell in a Report
    By CityOfKalamazoo in forum Reports
    Replies: 2
    Last Post: 07-28-2016, 09:22 AM
  2. Text box resize horizontally
    By cowboy in forum Reports
    Replies: 1
    Last Post: 06-09-2010, 09:30 PM
  3. Forcing text to upper case
    By barrettp in forum Forms
    Replies: 10
    Last Post: 06-01-2010, 09:44 AM
  4. Replies: 3
    Last Post: 10-15-2009, 12:24 PM
  5. Expand field horizontally
    By jonsuns7 in forum Reports
    Replies: 1
    Last Post: 10-15-2009, 04:54 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