Text box info on Form doesn't print all on Report

[CJ1]

I created a report from a form in Access 2K. When I run the report it
doesn't show all of the text that is typed in the text box on the form. I
change the CanGrow property to yes, change it to a memo field, etc. and it
still did not print all of the info. How do you make it show all of the info?

 

[CJ1 via AccessMonster.com]

Does anybody know how to fix this?

I created a report from a form in Access 2K. When I run the report it
doesn't show all of the text that is typed in the text box on the form. I
change the CanGrow property to yes, change it to a memo field, etc. and it
still did not print all of the info. How do you make it show all of the info?

 

[Gina Whipp]

Just a thought... Have you made sure the section CanGrow?

HTH,
Gina Whipp

 

[Duane Hookom]

Another check is open the report's record source in datasheet view and see
if all the characters are there. Is the text being truncated at 255
characters, more, or less?

--
Duane Hookom
MS Access MVP

Just a thought... Have you made sure the section CanGrow?

HTH,
Gina Whipp

 

[CJ1 via AccessMonster.com]

Yes

Just a thought... Have you made sure the section CanGrow?

HTH,
Gina Whipp

Does anybody know how to fix this?

[quoted text clipped - 3 lines]

 

[CJ1 via AccessMonster.com]

The area that isn't printing is a memo field (data type). I don't know what
you mean by the "text being truncated at 255 characters..."? Do I look under
design view in the forms and check the properties in that text box to find
that?

Another check is open the report's record source in datasheet view and see
if all the characters are there. Is the text being truncated at 255
characters, more, or less?

Just a thought... Have you made sure the section CanGrow?

[quoted text clipped - 10 lines]

 

[Duane Hookom]

Truncated means "doesn't show all of the text". It would be a good clue if
the shown text cut off at 255 characters.

I would like you to find the report's Record Source property and open it.
View the query in datasheet view to see if your text is truncated in the
record source. If so, reply back with the SQL view of your report's record
source.

--
Duane Hookom
MS Access MVP

The area that isn't printing is a memo field (data type). I don't know
what
you mean by the "text being truncated at 255 characters..."? Do I look
under
design view in the forms and check the properties in that text box to find
that?

Another check is open the report's record source in datasheet view and see
if all the characters are there. Is the text being truncated at 255
characters, more, or less?

Just a thought... Have you made sure the section CanGrow?

[quoted text clipped - 10 lines]

still did not print all of the info. How do you make it show all of
the
info?

 

[CJ1 via AccessMonster.com]

Here is the SQL View:

SELECT CaseTable.Hospital, CaseTable.CDSinitials, First(CDSlist.Name) AS
FirstOfName, CaseTable.PatientAccountNumber, CaseTable.SSN, CaseTable.MRN,
CaseTable.PtLastName, CaseTable.DischDisp, CaseTable.PtFirstName, CaseTable.
MedRecCoderInitials, Coders.Name, CaseTable.DiscDate, CaseTable.DiscDRG,
DRGtable_2.strDRGdescription, DRGtable_2.intWeight, CaseTable.[SOI APR],
CaseTable.[ROM APR], First(Coders.Name) AS FirstOfName1, CaseTable.[TC
Reviewed], CaseTable.TCcodechange, CaseTable.TCDRG, DRGtable_1.
strDRGdescription, DRGtable_1.intWeight, CaseTable.[NewSOI APR], CaseTable.
[NewRom Apr], CaseTable.[New APS], CaseTable.TCcommentToCDS, CaseTable.
DRGdiscrepReason, CaseTable.FinalCDSdrg, DRGtable.strDRGdescription, DRGtable.
intWeight, CaseTable.Auditor, CaseTable.TCcommentToCoder
FROM ((((CaseTable LEFT JOIN CDSlist ON CaseTable.CDSinitials = CDSlist.
Initials) LEFT JOIN Coders ON CaseTable.MedRecCoderInitials = Coders.Initials)
LEFT JOIN DRGtable ON CaseTable.FinalCDSdrg = DRGtable.strDRG) LEFT JOIN
DRGtable AS DRGtable_1 ON CaseTable.TCDRG = DRGtable_1.strDRG) LEFT JOIN
DRGtable AS DRGtable_2 ON CaseTable.DiscDRG = DRGtable_2.strDRG
GROUP BY CaseTable.Hospital, CaseTable.CDSinitials, CaseTable.
PatientAccountNumber, CaseTable.SSN, CaseTable.MRN, CaseTable.PtLastName,
CaseTable.DischDisp, CaseTable.PtFirstName, CaseTable.MedRecCoderInitials,
Coders.Name, CaseTable.DiscDate, CaseTable.DiscDRG, DRGtable_2.
strDRGdescription, DRGtable_2.intWeight, CaseTable.[SOI APR], CaseTable.[ROM
APR], CaseTable.[TC Reviewed], CaseTable.TCcodechange, CaseTable.TCDRG,
DRGtable_1.strDRGdescription, DRGtable_1.intWeight, CaseTable.[NewSOI APR],
CaseTable.[NewRom Apr], CaseTable.[New APS], CaseTable.TCcommentToCDS,
CaseTable.DRGdiscrepReason, CaseTable.FinalCDSdrg, DRGtable.strDRGdescription,
DRGtable.intWeight, CaseTable.Auditor, CaseTable.TCcommentToCoder
HAVING (((CaseTable.MedRecCoderInitials)=[Enter Coder Initials]) AND (
(CaseTable.DiscDate) Between [Beginning Date] And [End Date]) AND ((CaseTable.
DRGdiscrepReason)="2" Or (CaseTable.DRGdiscrepReason)="9"));

Truncated means "doesn't show all of the text". It would be a good clue if
the shown text cut off at 255 characters.

I would like you to find the report's Record Source property and open it.
View the query in datasheet view to see if your text is truncated in the
record source. If so, reply back with the SQL view of your report's record
source.

The area that isn't printing is a memo field (data type). I don't know
what

[quoted text clipped - 13 lines]

 

[Duane Hookom]

You are not producing more than 255 characters in any field other than maybe
CDSlist.Name and Coders.Name. That is why I asked if your text was
truncating in the record source query.

You have a totals/group by query. Access will limit any field in the GROUP
BY to 255 characters. You might be able to skirt this issue by using
First([Your Memo Field]) to get more than 255 characters.

--
Duane Hookom
MS Access MVP

Here is the SQL View:

SELECT CaseTable.Hospital, CaseTable.CDSinitials, First(CDSlist.Name) AS
FirstOfName, CaseTable.PatientAccountNumber, CaseTable.SSN, CaseTable.MRN,
CaseTable.PtLastName, CaseTable.DischDisp, CaseTable.PtFirstName,
CaseTable.
MedRecCoderInitials, Coders.Name, CaseTable.DiscDate, CaseTable.DiscDRG,
DRGtable_2.strDRGdescription, DRGtable_2.intWeight, CaseTable.[SOI APR],
CaseTable.[ROM APR], First(Coders.Name) AS FirstOfName1, CaseTable.[TC
Reviewed], CaseTable.TCcodechange, CaseTable.TCDRG, DRGtable_1.
strDRGdescription, DRGtable_1.intWeight, CaseTable.[NewSOI APR],
CaseTable.
[NewRom Apr], CaseTable.[New APS], CaseTable.TCcommentToCDS, CaseTable.
DRGdiscrepReason, CaseTable.FinalCDSdrg, DRGtable.strDRGdescription,
DRGtable.
intWeight, CaseTable.Auditor, CaseTable.TCcommentToCoder
FROM ((((CaseTable LEFT JOIN CDSlist ON CaseTable.CDSinitials = CDSlist.
Initials) LEFT JOIN Coders ON CaseTable.MedRecCoderInitials =
Coders.Initials)
LEFT JOIN DRGtable ON CaseTable.FinalCDSdrg = DRGtable.strDRG) LEFT JOIN
DRGtable AS DRGtable_1 ON CaseTable.TCDRG = DRGtable_1.strDRG) LEFT JOIN
DRGtable AS DRGtable_2 ON CaseTable.DiscDRG = DRGtable_2.strDRG
GROUP BY CaseTable.Hospital, CaseTable.CDSinitials, CaseTable.
PatientAccountNumber, CaseTable.SSN, CaseTable.MRN, CaseTable.PtLastName,
CaseTable.DischDisp, CaseTable.PtFirstName, CaseTable.MedRecCoderInitials,
Coders.Name, CaseTable.DiscDate, CaseTable.DiscDRG, DRGtable_2.
strDRGdescription, DRGtable_2.intWeight, CaseTable.[SOI APR],
CaseTable.[ROM
APR], CaseTable.[TC Reviewed], CaseTable.TCcodechange, CaseTable.TCDRG,
DRGtable_1.strDRGdescription, DRGtable_1.intWeight, CaseTable.[NewSOI
APR],
CaseTable.[NewRom Apr], CaseTable.[New APS], CaseTable.TCcommentToCDS,
CaseTable.DRGdiscrepReason, CaseTable.FinalCDSdrg,
DRGtable.strDRGdescription,
DRGtable.intWeight, CaseTable.Auditor, CaseTable.TCcommentToCoder
HAVING (((CaseTable.MedRecCoderInitials)=[Enter Coder Initials]) AND (
(CaseTable.DiscDate) Between [Beginning Date] And [End Date]) AND
((CaseTable.
DRGdiscrepReason)="2" Or (CaseTable.DRGdiscrepReason)="9"));

Truncated means "doesn't show all of the text". It would be a good clue if
the shown text cut off at 255 characters.

I would like you to find the report's Record Source property and open it.
View the query in datasheet view to see if your text is truncated in the
record source. If so, reply back with the SQL view of your report's record
source.

The area that isn't printing is a memo field (data type). I don't know
what

[quoted text clipped - 13 lines]

the
info?

 

[CJ1 via AccessMonster.com]

I already have it set as a memo field....so should I take off the group by...?

You are not producing more than 255 characters in any field other than maybe
CDSlist.Name and Coders.Name. That is why I asked if your text was
truncating in the record source query.

You have a totals/group by query. Access will limit any field in the GROUP
BY to 255 characters. You might be able to skirt this issue by using
First([Your Memo Field]) to get more than 255 characters.

Here is the SQL View:

[quoted text clipped - 49 lines]

 

[Duane Hookom]

Re-read my previous reply.

--
Duane Hookom
MS Access MVP

I already have it set as a memo field....so should I take off the group
by...?

You are not producing more than 255 characters in any field other than
maybe
CDSlist.Name and Coders.Name. That is why I asked if your text was
truncating in the record source query.

You have a totals/group by query. Access will limit any field in the GROUP
BY to 255 characters. You might be able to skirt this issue by using
First([Your Memo Field]) to get more than 255 characters.

Here is the SQL View:

[quoted text clipped - 49 lines]

the
info?