Wrox Programmer Forums
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
Old August 4th, 2005, 11:05 AM
Friend of Wrox
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default Dynamic Report Design

Here is one to make you scratch your head...

I have some code that creates and prints a letter (report) on the fly. The letter includes a body section and then inserts the user's signature as a graphic. The problem is that the body section varies between 2 and 6 lines, and makes placement of the signature tricky. I have been using a character count to determine how many lines to skip, but using a variable width font, makes this unreliable. I have experimented making the body into a textbox, but apparently Access won't let me set the text property while it is being designed.

Anyone have any good ideas?

Thanks in advance,


Old August 8th, 2005, 02:40 AM
Friend of Wrox
Join Date: Jul 2005
Posts: 150
Thanks: 0
Thanked 0 Times in 0 Posts

Why is the placement tricky?

Place the image control below the control you where want it. If you use can grow, then the image will automatically move.

You could also place the image control in a group footer. IMHO, this is where it really should be.


"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.

Similar Threads
Thread Thread Starter Forum Replies Last Post
How To:Develope and Design dynamic Menu jadhav_nilesh_p BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 1 November 21st, 2006 12:58 PM
Create crystal report design dynamically. velmurugan Crystal Reports 0 September 9th, 2006 12:53 AM
Report change in Design View echovue Access VBA 4 March 3rd, 2006 04:31 PM
Grouping Header/Footer in VB 6 Report Design Oyero VB How-To 1 February 18th, 2005 09:29 AM
Report Design maha Access 3 January 8th, 2004 09:04 AM

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