Formatting line/carriage returns?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that displays as below. Is there a way to get
Course Name to line up on one line?
Fall Winter Spring

Course Name
Course Name
Course Name
 
Do you have a sample record or two so we can see what you are working with?
I think you can use code like Me.MoveLayout = False but you haven't provided
near enough information.

--
Duane Hookom
MS Access MVP


Donna said:
I have a report that displays as below. Is there a way to get
Course Name to line up on one line?
Fall Winter Spring

Course Name
Course Name
Course
Click to expand...
Name
 
These are the fields in the table:

TERM Subj Crs CRN Title Instructor Begin End Days Room Bldg EnrlMax EnrlCur Prereq Notes Approval Attrib XCode UDR Key SpecTop Area GF
200301 ENG 104 11779 Intro Literature Wood,
Mary| 900 950 MWF 229 MCK 95 94 Fiction |1| 1 Yes Early American
200301 ENG 104 11780 Intro Literature Dugaw,
Dianne 1200 1250 MWF 360 CON 40 40 Fiction |1| 5 No 19th Century American
200301 ENG 104 11781 Intro Literature Wonham,
Henry 1400 1450 MWF 207 CHA 100 100 Fiction |1| 4 Yes 18th Century

TERM Subj Crs CRN Title Instructor Begin End Days Room Bldg EnrlMax EnrlCur Prereq Notes Approval Attrib XCode UDR Key SpecTop Area GF
200302 ENG 613 21826 GTF Comp Apprentice Morse, Andrew 20 11 611 or
equiv M No
200302 ENG 670 21828 Top Modernism & Empire Peppis,
Paul 1700 1950 M 253 PLC 15 17 M No
200302 WR 121 24736 College Composit I Krane,
Denise 1400 1450 MWF 301 GER 26 11 Dept placement exam be D |WR| No
This is a result from the query that runs the report:

Instructor Term1 Course1 Title1 Enrl1 Begin1 End1 Days1 Term2 Course2 Title2 Enrl2 Begin2 End2 Days2 Term3 Course3 Title3 Enrl3 Begin3 End3 Days3 GF UCRN GCRN
Appel, Ian 200303 122 College Composit
II 21 1600 1720 UH 35295 0
Appel, Ian 200302 121 College Composit
I 20 1800 1920 UH 24768 0
Appel, Ian 200301 121 College Composit
I 26 1300 1350 MWF f 14866 0

What I want to have happen is the courses that Ian Appel teaches for Fall,
Winter & Spring should be on one line in the report, but they end up more
like "steps"
 
I'm sorry but I don't want to spend the time it takes to figure where field
names and data begin and end. Could you maybe reply with the significant
fields? Your original posting looked like there were about 2-3 important
fields.

--
Duane Hookom
MS Access MVP


Donna said:
These are the fields in the table:

TERM Subj Crs CRN Title Instructor Begin End Days Room Bldg EnrlMax
Click to expand...
EnrlCur Prereq Notes Approval Attrib XCode UDR Key SpecTop Area GF
200301 ENG 104 11779 Intro Literature Wood,
Mary| 900 950 MWF 229 MCK 95 94 Fiction |1| 1 Yes Early American
200301 ENG 104 11780 Intro Literature Dugaw,
Dianne 1200 1250 MWF 360 CON 40 40 Fiction |1| 5 No 19th Century American
200301 ENG 104 11781 Intro Literature Wonham,
Henry 1400 1450 MWF 207 CHA 100 100 Fiction |1| 4 Yes 18th Century

TERM Subj Crs CRN Title Instructor Begin End Days Room Bldg EnrlMax
Click to expand...
EnrlCur Prereq Notes Approval Attrib XCode UDR Key SpecTop Area GF
200302 ENG 613 21826 GTF Comp Apprentice Morse, Andrew 20 11 611 or
equiv M No
200302 ENG 670 21828 Top Modernism & Empire Peppis,
Paul 1700 1950 M 253 PLC 15 17 M No
200302 WR 121 24736 College Composit I Krane,
Denise 1400 1450 MWF 301 GER 26 11 Dept placement exam be D |WR| No
This is a result from the query that runs the report:

Instructor Term1 Course1 Title1 Enrl1 Begin1 End1 Days1 Term2 Course2
Click to expand...
Title2 Enrl2 Begin2 End2 Days2 Term3 Course3 Title3 Enrl3 Begin3 End3 Days3
GF UCRN GCRN
 
sorry, your 1st message back to me sounded like you wanted more detailed info.

I have a table that has course names, teachers, days of week, room #, etc.
I have a query that returns Course 1 and all its pertinent info for all
courses that are in the first term, then another field Course 2 (time2, etc)
for all courses in the 2nd term, and Course 3, time 3, etc for all courses in
the 3rd term.
This data is sorted by instructor name.
I then have a report as follows:
Fall 2003 Winter 2004
Spring 2004

Course Name etc Course Name etc
Course Name etc
Bill Smith Eng 101
Folklore
486

Eng 265

What I'd like is:

Bill Smith Eng 101 Folklore 486
Eng 265
 
Does your previous message look as word wrapped to you as it does to me. Let
me make a stab at this. Create a Group footer section on the instructor and
make it exactly the same height as the detail section. Then add code in the
On Format event of the detail section:
Me.MoveLayout = False
 
Back
Top