Access 2003: SubReport - how to "dually" use fields - either indiv info or 1 long comment

Hi EE,

For this question, uploaded mdb with 3 reports.
parent
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
2011-03-24-rpt.GIF
2011-03-24-EE-ARG-14-Transcript-.zip
mytfeinAsked:
Who is Participating?
 
Simon BallCommented:
can you run it with that field / section properties set to can grow = true.

that should let the field expand to show more lines?

i'll have go
0
 
Simon BallCommented:
yes done it.

set that field in the report to cangrow = true.
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
mytfeinAuthor Commented:
Hi Sudonim,

tx so much for writing...

it works and is beautiful....

s
0
 
Simon BallCommented:
my pleasure.  i think your line on the report... the verticle one... can it grow too? image of design issue i noticed after providing solution
0
 
mytfeinAuthor Commented:
hi sudonim,

oops, good point....  i guess i should set the line to "can grow", too?

will go fix it...

tx for catching it... s
0
 
mytfeinAuthor Commented:
Hi Sudonim,

just checked.... a line does not have a "can grow" property....

i can live with it... if that's the way it is...

tx, s
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.