Access 2000 Report lines spacing & formating

[KevinC]

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

 

[david epsom dot com dot au]

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)