Solved

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

Posted on 2011-03-23
7
328 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
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…

919 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now