Solved

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

Posted on 2011-03-23
7
329 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 500 total points
ID: 35205219
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

770 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