Text Box

[Don]

Is there a way to have a vertical label or text box spans
an entire detail area? Is there a property I can set?
for the detail area or the text box itself?


I have several rows of records in my report. I'd love to
be able to put "Technician" in a vertical text box that
spans the entire detail area (not each record).

It is unlikely that the report will ever be more than one
page. It's not a make or break thing, just something
fancy to impress people.

Thanks in advance for any advice.
Don


Don

 

[Duane Hookom]

Check the watermark logo sample at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. It uses Me.MoveLayout =
False to "overlay" more than one report section.

 

[fredg]

Is there a way to have a vertical label or text box spans
an entire detail area? Is there a property I can set?
for the detail area or the text box itself?

I have several rows of records in my report. I'd love to
be able to put "Technician" in a vertical text box that
spans the entire detail area (not each record).

It is unlikely that the report will ever be more than one
page. It's not a make or break thing, just something
fancy to impress people.

Thanks in advance for any advice.
Don

Don

Here's the general idea.

Add a label to the PAGE HEADER.
Type your text into it.
Size it narrow so the letters are aligned, one under the other, (or
add a carriage return after each letter).
Size it's length (as well as the Page Header length) to the length of
the paper used, less the top and bottom margins, i.e. 9" on an 11"
page using a 1 inch top and bottom margin. If you use a page footer,
take that height into account also.
Adjust the label's Line Space property as well as it's top and bottom
margin properties as needed.

Code the Page Header Format event:
Me.MoveLayout = False

Place whatever controls you need in the Detail section.
Run the report.
Adjust the spacing as needed.