MS Access Report Printing?

Question

I have created a report in a MS Access database. I have the problem that it keeps printing an extra "blank" line between detail records. I have the can grow and can shrink property turned on. However, it sets the size based on the largest content.

report sample:

xxx xxxxxxxxxxxx

xxx xxxxxxxxxxxx

xxx xxxxxxxxxxxxx
----- xxxxxxxxxxxxx (dashes are not in the report)
xxx xxxxxxxxxxxxx
----- xxxxxxxxxxxxx (dashes are not in the report)
----- xxxxxxxxxxxxx (dashes are not in the report)

The extra line causes quite a waste of paper. I already know that based on a category, the text box would be limited to 1 line, while based on some specific category, the text box could grow.

Does anyone know how I can programatically removed the extra line in the report? I added a few line of code to the "detail" section on the [on format] property, but I get an error that based on the category I can't reassigned the value of the 'cangrow' property for each text box.

I would appreciate your guidance.

Answer 1

The "Can grow" and "Can shrink" must be applied to all fields within the group. Also they must not be overlapping each other.



I find this usually works, after fiddling about with the position of the fields. Make sure the "Top" of the lower field is the same as "Top" plus "Height" of the field above it.

Answer 2

MS Access Report Printing?



Silly thought but have you adjusted the detail height? There should be no extra space below the lowest placed control in the detail area which may appear to have an extra line!



Try dragging the base of the detail line up and even over the whole details section even over the controls it will bounce down to the lowest placed control. This may even reveal a blank (or what appears to be a hidden control too if it settles lower than you expect).



Without sending the report design (on its own), I can't help you fur her.



Ben Beitler

Answer 3

the respond lies interior the properties of the document. interior the layout view of the document, precise click the "shopper.CustomerNum Header" and click "properties." click the "format" tab and on the line that asserts, "stress New internet site," set it to "until now section." Cheers!