Results 1 to 8 of 8
  1. #1
    digitaldb is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    16

    Can Header be centered of 2 or more columns

    I have a simple database that I use to keep up with IP Address assignment in a network that only uses static IP Addresses. I have a report that shows me two fields, addresses that have been assigned and a description of where that address is used. The report is setup to do 2 columns, left to right, then down. I would like to center the header over both columns but I don't see any possible way to do that. Ill upload a copy and you will need to view the report in "print preview" to see the columns and how the header will only work over the left column.
    Attached Files Attached Files

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    can you not put the header over the 2 columns, stretch the box over both, then center the text?

  3. #3
    digitaldb is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    16
    In design view, the report is under 4" wide so you can only see the left column, so there is no way to make the header label wider there. That's necessary for letter size printing.
    Click image for larger version. 

Name:	design view.png 
Views:	18 
Size:	6.4 KB 
ID:	26770
    Then under page setup and columns, 2 columns are selected, and the print preview and printout looks like this
    Click image for larger version. 

Name:	print preview.png 
Views:	18 
Size:	9.5 KB 
ID:	26771

  4. #4
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    If you change the color of the Page Header it will stretch all the way across - doesn't fix your problem but may be a workaround.

  5. #5
    AccessPower's Avatar
    AccessPower is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2016
    Posts
    165
    You can change the width of the columns. By default they match the width of the detail. You can expand the width of the header, then set your columns to a custom size. See attached.

    For future reference this modification is done under the layout view, click on columns and uncheck the box that says "Same as detail."

    -Static IP Addresses.zip
    Last edited by AccessPower; 12-19-2016 at 01:02 PM. Reason: File added

  6. #6
    digitaldb is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    16
    Quote Originally Posted by AccessPower View Post
    You can change the width of the columns. By default they match the width of the detail. You can expand the width of the header, then set your columns to a custom size. See attached.

    For future reference this modification is done under the layout view, click on columns and uncheck the box that says "Same as detail."

    -Static IP Addresses.zip
    Thanks Accesspower, that's what I was looking for..... How do I mark this solved ?

  7. #7
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922

  8. #8
    AccessPower's Avatar
    AccessPower is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2016
    Posts
    165
    You're welcome

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

Similar Threads

  1. Replies: 1
    Last Post: 06-15-2016, 08:45 AM
  2. Background colour when Form centered
    By jcc285 in forum Forms
    Replies: 4
    Last Post: 03-13-2015, 12:43 PM
  3. Replies: 1
    Last Post: 04-06-2014, 10:58 AM
  4. Multiple columns with wide group header
    By jeh35 in forum Reports
    Replies: 3
    Last Post: 08-22-2013, 12:09 AM
  5. columns for group detail but not group header?
    By Coolpapabell in forum Reports
    Replies: 0
    Last Post: 08-21-2009, 08:53 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