I haven't tested it yet, because the memo field became a huge problem and the headmaster had a panic attack. But the header is minimal at this point. I am sorry I should have clarified.
D.
Duane,
For every subject (math, science, history etc...) there are long narratives in memo fields. Every header has at least two or three memo fields that are being cut off. The full memo field is in the table, I tested them all. So every header section has a few memo fields within it that...
There is a further problem here. I just ran a simple report with two of the fields that are cut ff in my main report, and in a basic report, all the information displays. How can the same table generate a correct field in one report and a cut field in another?
Hi All,
I have read many posts about the external data imports. I am importing Excel spreadsheets into tables. I have created the tables in Access already, and have defined the columns as Memo fields when the excel cells contain paragraphs. Yet, when I run the reports, the cut at 255...
Hi,
I have GroupHeader2 which has inside it the textbox student.
I would like all of groupheader2 to not show if student is null.
So I selected the 'on format' event for GroupHeader2 and entered the following code:
If student is null
then groupheader2.visible is false
else...
Thank you Duane,
I implemented your recommendation, and after a while to build the huge query (220 fields I believe) I created a report with 9 headers. The problem I am encountering is that parts of the 220 fields for Student A are actually showing information for student B. I don't...
Sorry for the delay in reply Duane. I am not sure I understand what you are inferring. I have five subjects, each 3 to 4 pages. I create an unbound master report, and create a sub report for each subject, correct? What do you mean by creating sections of the main report?
Thanks for...
Yes I am. Every subject has narrative sections (that require memo fields) plus specific fields. The math report alone is 3 pages long, and same for three of the four others. Per kid, each total report is approximately 15 pages. If I create a master report, and bound the other reports as sub...
I have created reports for five academic subjects: math, humanities, physics, foreign languages etc...They each run more or less the maximum length of a report (22 inches or so). Is there anyway to group all these reports into a master report? In other word, with the student name as an...
Good evening all,
I have a very simple query with many field (38 text fields and 5 memo fields). For some reason, the memo fields in some records get truncated and not at other times! I have read about access truncating memo fields, but this is simple. Everything is made to grow, there are no...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.