Access2003: How do I remove white space Access adds when a text report is emailed
Posted on 2010-11-24
I apologise for the length of the question but I want to present as much info as possible. I support an old Access database (originally 97, now 2003) that is used to build letters sent to test candidates. The letters are sent to people all over the world and must be emailed in text format. The letters are built from data passed to the Access database from a Java application, data retrieved from an SQL Server database and templates stored in the Access database.
Access occaisionally, with no discernable rhyme or reason, adds varying amounts of white space (extra blank lines) between sections of a report. This doesn't happen for every client and every letter type but does happen consistently for certain clients for a specific letter type.
The report templates consist of a number of sections. There are page header and footer, section headers and footers and a detail section. Which sections are to be printed are determined by the location in the world to which the report is to be sent, the client for whom the letter is being sent, and the specific contents (cost, discount, fees, and the like) the client selected. One section that is included in the template contains a text field that holds custom text for the specific client. This text box is immediately before the report footer.
Part of the formatting of the text box and the following section includes imbedded blank lines (CR+LF characters). There are 2 sets at the end of the custom text and 3 sets at the start of the text in the next section.
The report displays as it should in print preview mode (as plain text) but when it is sent via email (also as plain text) there are an additional 25 blank lines between the two sections. I've checked the can grow and can shrink settings for both the text box and the report section that contains it and all are set to yes to allow growth or shrinking.
Any ideas that can identify a cause and or a solution will be greatly appreciated.