Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2011-03-23
7
Medium Priority
?
338 Views
Last Modified: 2012-08-14
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
0
Comment
Question by:mytfein
  • 4
  • 3
7 Comments
 
LVL 15

Expert Comment

by:Simon Ball
ID: 35205173
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
 
LVL 15

Expert Comment

by:Simon Ball
ID: 35205212
yes done it.

set that field in the report to cangrow = true.
0
 
LVL 15

Accepted Solution

by:
Simon Ball earned 2000 total points
ID: 35205219
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:mytfein
ID: 35208464
Hi Sudonim,

tx so much for writing...

it works and is beautiful....

s
0
 
LVL 15

Expert Comment

by:Simon Ball
ID: 35214150
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
 

Author Comment

by:mytfein
ID: 35215213
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
 

Author Comment

by:mytfein
ID: 35215232
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question