Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Report "Text too long to be edited"

Status
Not open for further replies.

Hulm1

Technical User
Mar 11, 2008
100
GB
Hi
I wanted to add some Terms and Conditions to an access report (a quotation). However, these run to two pages and I wanted to simply tack them on , and force a new page for each. However, I don't know how to add them. I tried simply adding a Label for each and filling it with the text but I get the "text too long to be edited" error.

Can someone please advise?
Thanks
 
I like to keep data in my tables, not in caption properties of label controls. Create a table of terms and conditions using a memo field for each. Then use a subreport to display these on in your report.

Duane
Hook'D on Access
MS Access MVP
 
Ah yes! Thank you. I will do that tomorrow when I am back in the office. I appreciate your help
 
Ok that works great. I had to add a TermsID to my Quote Table and simply default it to one. This then forms the parent child relationship. Unless there is a better way?

Is it also possible to suppress the page header information on the pages with the terms and conditions? Obviously it doesn't look right to have items, rate, quantity headers etc. at the top of that page!

Thanks
 
I'm not positive on the hiding main page header sections on the pages with only the terms. I think you would need some code to cancel the display in the On Format event of the page header section.

Duane
Hook'D on Access
MS Access MVP
 
The issue is that in the Report footer I have a Grand Total.
I put the Terms and conditions subreport into the report footer (under the Grand Total)and inserted a page break just before it. For some reason I cannot fathom, the grand total is pushed to the top of it's own page, even though the main body of the report may only take up half of the first page. If I remove the subreport, the Grand Total appears on the first page and the end of the report detail.

errr... help?

Q

Meanwhile on the page header I selected "Not with report footer" which answers one of queries
 
You could try to create a new top level sorting and grouping on a constant expression like =1. Display the Group Footer for this level and use it to display your report Grand Total. Then your report footer will contain only the terms.

Duane
Hook'D on Access
MS Access MVP
 
Sorry, but could you possibly be a bit more clear? I delve in an out of access. I am looking at the Sorting and Grouping as I write this. The only sorting I have is on QuoteCategoryID at the moment.

I am not clear how to do what you suggest. I mean the =1 one bit and how that relates to my report.

Sorry!
 
You haven't stated what version of Access you are using. In pre-2007 you would open the Sorting and Grouping dialog and type
Code:
  =1 
in the Field/Expression column. Then drag it to the top so it is the first row. Set its Group Footer property to Yes. Use this footer section to display your grand total.
[tt]
+------------------------------------
| Field/Expression |  Sort Order
+------------------+-----------------
|  =1              | Ascending
|[QuoteCategoryID  | Ascending
|                  |
[/tt]

[COLOR=Blue][B][I]Duane
[url=http://www.access.hookom.net/]Hook'D on Access[/url]
[url=https://mvp.support.microsoft.com/profile/Duane.Hookom]MS Access MVP[/url][/I][/B][/color]
 
That's done it. I didn't know you could have Group Footers. You'd almost thing someone had thought this through!

Thanks again
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top