If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2000 Report lines spacing & formating
I have a report derived from a single record consisting of a page header
plus a detail section consisting of 40 to 50 textboxes whose pupose is to produce a formated print for posting to the customer. The contents of the textboxes are derived from memo fields or VBA functions which concatenate strings and data from several fields. All text boxes span the completed width of the report CanGrow and CanShrink is set to yes on both detail section and all textboxes.Some fields or functions return null and those textboxes must not result in blank lines. My problem is that access insists on putting a small space between each textbox no matter how I set the height of the textbox ( I guess because the can grow automatically sets it for the font size) but when a textbox extends to two or more lines the spacing is more codensed this gives the finished document inconsistant line spacing and a less than professional appearance. Setting the line spacing property of the textboxes to any value to try and even the spacing causes blank lines to appear or the final line of the textbox to dissappear, (only the final line it does not matter how many lines). No text boxes overlap and it works perfectly if all text boxes consist of only one line. This is really bugging me am I doing something wrong, or is this a bug in access. Another niggle is text boxes can break across pages which I would prefer them not to. Any Help would be appreciated. Kevin |
#2
|
|||
|
|||
strings and data from several fields. All text boxes span the
width of the report CanGrow and CanShrink is set to yes on Create a table and bind the report to the table Make each value one record in the table. In the Open event of the report, empty the table, then write the values into the table. (david) "KevinC" wrote in message ... I have a report derived from a single record consisting of a page header plus a detail section consisting of 40 to 50 textboxes whose pupose is to produce a formated print for posting to the customer. The contents of the textboxes are derived from memo fields or VBA functions which concatenate strings and data from several fields. All text boxes span the completed width of the report CanGrow and CanShrink is set to yes on both detail section and all textboxes.Some fields or functions return null and those textboxes must not result in blank lines. My problem is that access insists on putting a small space between each textbox no matter how I set the height of the textbox ( I guess because the can grow automatically sets it for the font size) but when a textbox extends to two or more lines the spacing is more codensed this gives the finished document inconsistant line spacing and a less than professional appearance. Setting the line spacing property of the textboxes to any value to try and even the spacing causes blank lines to appear or the final line of the textbox to dissappear, (only the final line it does not matter how many lines). No text boxes overlap and it works perfectly if all text boxes consist of only one line. This is really bugging me am I doing something wrong, or is this a bug in access. Another niggle is text boxes can break across pages which I would prefer them not to. Any Help would be appreciated. Kevin |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Has anyone seen this behaviour? What might it be? | tw | General Discussion | 4 | June 30th, 2005 03:23 PM |
Can One Use Access 2003 on Access 2000 Databases? | lbrinkman | New Users | 2 | January 14th, 2005 11:13 PM |
Printing OLE Object in a Access 2000 report | Edgard | Setting Up & Running Reports | 0 | December 5th, 2004 09:21 PM |
Access 2000 -vs- Access 2003? | Mark | General Discussion | 5 | November 30th, 2004 06:36 AM |
Save Report With CreateReport Coding Issue | Jeff Conrad | Setting Up & Running Reports | 8 | July 12th, 2004 08:39 AM |