Add textbox to first page of report

[vanHel]

Hi there.

I´ve a problem during the development of a report. I´m generating reports from a query with a variable number of pages depending on the recordsets selected before. As I would like to send these reports to customers I need to have a textbox containing company information on each first page of any report.

I tried it with an invisible textbox on each page of a report being visible only on the first page. But that screws the format of the report.

Is there a possibility to add a textbox to a report after it was generated, but before the report is shown to the user? The textbox always contains the same contents.


Thanks in advance!!!

 

[TomCologne]

If you put the textbox in the Report Header it will only appear once per report.

In case you need to add the header set the "Force New Page" property to "After Section" to maintain the current format.

To make the textbox invisible for print out, put something
like

Me!txtTextboxName.Visible = False

behind the OnPrint event of the report.

TomCologne

 

[vanHel]

Thanks Tom!

The problem is that the textbox has to be besides the contents on the left side of the report. As the text box has a lot of rows a format problem occurs when the details about a recordset have fewer rows than the text box. Even if invisible the textbox having more rows than the details text causes free spaces between paragraphs.

I appreciate any hints!

 

[Bokazoit]

Can You be more specific?...I don't see the problem very clear since a textbox keeps the format choosen by You

 

[vanHel]

The textbox (about one third of a page high) has to be placed in the lower left part of the report. So it can´t be located in a header or footer.

The details area for recordsets consists of two components: a 'header area' for each recordset, and a 'text area' depending on the header area. (strange construction, was already in place when I began to work on it...) The 'header area' has only one row, so it is to narrow for the textbox and I included the textbox into the 'text area'. For each 'header area' in the report Access attaches the textbox once even if invisible.

In most cases the 'text areas' for a recordset are not as high as the textbox, so there is a lot of free space between the recordsets.

As it seems impossible for me to include the textbox in the way mentioned above I would like to add it after the pages of the report have been created.

 

[TomCologne]

I'm not sure if I'm getting this correctly, but it sounds like your textbox is in the Page Header section!?

A textbox can be placed on the bottom of the page in the Report Header section, "header" just means that it will only appear once on the first page of each report.

I don't know how familiar you are with reports but I recall
the frustrating hours I spent in Design View before I started getting the idea behind the different sections and how to use them.

TomCologne

 

[vanHel]

I appreciate all of your replies.

The textbox can´t be placed in the header or footer section as it has to appear besides (on the left side) the contents of the report (design standard of my company...).

The height of the textbox (about one third of a page) causes in a lot of cases blank spaces between recordsets as for each recordset Access includes the textbox once. So I began searching for other possibilities than placing the textbox in a certain section of the report.

... desperately searching ...