printing in detail section from 2nd page onwards

  • Thread starter Thread starter Lijo Jose
  • Start date Start date
L

Lijo Jose

I would like to know 2 matters.
1. I need to print some bound text controls (comes from a query) from 2nd
page onwards. And the same time, my plan is to print a text "See attached
page" in 1st page.
2. Some text / label controls(they are unbound), I would like to print on
bottom of 1st page only.

Please help me.

Thank you
Best regards
Lijo.
 
Change the Control Source of the text box to something like this:
=IIf([Page]=1, "See attached page", [SomeField])
substituting your field name for SomeField.

Be sure to change the Name of the text box as well. Access gets confused if
a control has the same name as a field, but is bound to something else.

You may also need to handle the formatting. For example, if SomeField is
Currency type, use:
=IIf([Page]=1, "See attached page", Format([SomeField], "Currency"))

Note that the record(s) on page 1 or your report will not print, i.e. you
get this text *instead* of the data. If you just want a title page, with all
the data on subsequent pages, place some text boxes or labels in the Report
Header section instead.
 
Thank you, Allen.

I tested but still there are some issues.

Point 1 : There are 9 receords, so "See attached page" comes 9 times. But I
like to print only once. And the 9 records do not come on 2nd page.
Point 2 : There are some labels like "Sign : ", "Received by : " etc.
These labels & text boxes (All are unbound controls) I arranged in Report
Footer Section. I would like to print these parameters in the bottom of the
1st page.

Could you please look into this?

Thans for your help.




Allen Browne said:
Change the Control Source of the text box to something like this:
=IIf([Page]=1, "See attached page", [SomeField])
substituting your field name for SomeField.

Be sure to change the Name of the text box as well. Access gets confused if
a control has the same name as a field, but is bound to something else.

You may also need to handle the formatting. For example, if SomeField is
Currency type, use:
=IIf([Page]=1, "See attached page", Format([SomeField], "Currency"))

Note that the record(s) on page 1 or your report will not print, i.e. you
get this text *instead* of the data. If you just want a title page, with all
the data on subsequent pages, place some text boxes or labels in the Report
Header section instead.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Lijo Jose said:
I would like to know 2 matters.
1. I need to print some bound text controls (comes from a query) from 2nd
page onwards. And the same time, my plan is to print a text "See attached
page" in 1st page.
2. Some text / label controls(they are unbound), I would like to print on
bottom of 1st page only.

Please help me.

Thank you
Best regards
Lijo.
Click to expand...
Click to expand...
 
I have to assume that you asked the wrong question. Apparently you do not
want "See attahced page" everyone it occurs on page 1.

Ignore the reply I gave you. Revert to the way you had the report before.
Instead, just add them to the Report Header section.
They will print at the top of the first page.
Then the data will print correctly below that.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Lijo Jose said:
Thank you, Allen.

I tested but still there are some issues.

Point 1 : There are 9 receords, so "See attached page" comes 9 times. But
I
like to print only once. And the 9 records do not come on 2nd page.
Point 2 : There are some labels like "Sign : ", "Received by : "
etc.
These labels & text boxes (All are unbound controls) I arranged in Report
Footer Section. I would like to print these parameters in the bottom of
the
1st page.

Could you please look into this?

Thans for your help.




Allen Browne said:
Change the Control Source of the text box to something like this:
=IIf([Page]=1, "See attached page", [SomeField])
substituting your field name for SomeField.

Be sure to change the Name of the text box as well. Access gets confused
if
a control has the same name as a field, but is bound to something else.

You may also need to handle the formatting. For example, if SomeField is
Currency type, use:
=IIf([Page]=1, "See attached page", Format([SomeField], "Currency"))

Note that the record(s) on page 1 or your report will not print, i.e. you
get this text *instead* of the data. If you just want a title page, with
all
the data on subsequent pages, place some text boxes or labels in the
Report
Header section instead.

Lijo Jose said:
I would like to know 2 matters.
1. I need to print some bound text controls (comes from a query) from
2nd
page onwards. And the same time, my plan is to print a text "See
attached
page" in 1st page.
2. Some text / label controls(they are unbound), I would like to print
on
bottom of 1st page only.

Please help me.

Thank you
Best regards
Lijo.
Click to expand...
Click to expand...
Click to expand...
 
I tried many ways, but still not coming to final way. Please help me.

Criteria based query generates many records. And one record may print in
one line or may use 2 or 3 lines. Like, if 7 records are there, it will take
minimum 7 lines. But detail section has the space to print 6 lines and the 7
the line goes to 2nd page. But in that case, I would like to print all 7
lines in 2nd page only. And the first page has to show "See attached sheet",
only once.

And if the no. of records are less than 6, all the records has to come in
first page and so no need to show the message "See attached sheet".

Kindly look into this.

Many thanks

Allen Browne said:
I have to assume that you asked the wrong question. Apparently you do not
want "See attahced page" everyone it occurs on page 1.

Ignore the reply I gave you. Revert to the way you had the report before.
Instead, just add them to the Report Header section.
They will print at the top of the first page.
Then the data will print correctly below that.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Lijo Jose said:
Thank you, Allen.

I tested but still there are some issues.

Point 1 : There are 9 receords, so "See attached page" comes 9 times. But
I
like to print only once. And the 9 records do not come on 2nd page.
Point 2 : There are some labels like "Sign : ", "Received by : "
etc.
These labels & text boxes (All are unbound controls) I arranged in Report
Footer Section. I would like to print these parameters in the bottom of
the
1st page.

Could you please look into this?

Thans for your help.




Allen Browne said:
Change the Control Source of the text box to something like this:
=IIf([Page]=1, "See attached page", [SomeField])
substituting your field name for SomeField.

Be sure to change the Name of the text box as well. Access gets confused
if
a control has the same name as a field, but is bound to something else.

You may also need to handle the formatting. For example, if SomeField is
Currency type, use:
=IIf([Page]=1, "See attached page", Format([SomeField], "Currency"))

Note that the record(s) on page 1 or your report will not print, i.e. you
get this text *instead* of the data. If you just want a title page, with
all
the data on subsequent pages, place some text boxes or labels in the
Report
Header section instead.

I would like to know 2 matters.
1. I need to print some bound text controls (comes from a query) from
2nd
page onwards. And the same time, my plan is to print a text "See
attached
page" in 1st page.
2. Some text / label controls(they are unbound), I would like to print
on
bottom of 1st page only.

Please help me.

Thank you
Best regards
Lijo.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top