Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old January 30th, 2005, 09:23 PM
Registered User
 
Join Date: Jan 2005
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access Report Detail

I have a report based on a query that I need to have vertical lines on. I have managed to figure out how to draw the lines but when the number of records that the query pulls is few, the lines only print to the last record in the detail and leaves a huge gap to the page footer. Anyone know how to overcome this problem?

Thanks

Lance Patterson

  #2 (permalink)  
Old January 30th, 2005, 10:50 PM
Authorized User
 
Join Date: Jan 2005
Location: Pinckneyville, IL, USA.
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to mnoon Send a message via MSN to mnoon Send a message via Yahoo to mnoon
Default

You may need to check the scroll bars in the details section, and verify how the size in height and width. I would check the properties of each section, top, details, and footer for those properties.

Regards,


Marc Noon

Coding is a game. Live it, love it, break it, run it.
  #3 (permalink)  
Old January 31st, 2005, 08:19 PM
Registered User
 
Join Date: Jan 2005
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Marc. I opened the report in design view and checked the detail and header sections and no properties for scroll bars on any. No top properties either. Any other suggestions will be gretaly apprecited.

Thanks,

Lance



Similar Threads
Thread Thread Starter Forum Replies Last Post
Refresh report when detail changes Ron Howerton Javascript How-To 21 October 8th, 2008 07:45 AM
Crystal report Freeze detail section. dpkbahuguna Beginning VB 6 0 August 23rd, 2007 05:29 AM
Change size of the Detail section of Forms/Report sinajs Access 1 February 13th, 2007 01:05 PM
Shrink Detail section on a report TimLB Access 2 January 23rd, 2007 08:45 AM
Formatting Report Detail Section rickf Access 3 February 3rd, 2004 07:15 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.