For this question, uploaded mdb with 3 reports.
subReport1 - acts as column 1
subReport2 - acts as column 2
This is a student progress report. Col 1 shows the fall classes, Col2 shows the spring classes
Each line in the col has these bound fields:
Subject Course Number Start Date End Date Course Title Credits Grade
The above fields come from TBL_Transcript.
The entire report is driven by TBL_Transcript.
I was asked to incorporate comments from the comments table, So I did an SQL insert into
TBL_Transcript from TBL_Comments, essentially using the comments as a "fake class".
I places the comments in the course title field, however the comments can be longer.
So my question is, how can i use the row's real estate, that is now occupied by individual
fields, to sometimes morph into 1 long field for a longer comment?
I suppose i can replace the indiv fields with 1 long fields and condition as to what to populate.
Am concerned that if i string up a bunch of fields with ampersands and spaces, the info
will not line up neatly.
Below is a screen shot of subReport 1.
If you want to see the entire report, you can just run RPT_020_Transcript,
tx for your help and ideas, sandra