Solved

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

Posted on 2011-03-23
7
331 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

730 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