Report 'Text Box Control Does Not Show All Information

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

Guest

Hi,
I need help in making the report show the whole text in the report. These
are the control attributes currently employed in my report.

Grouping & Sorting:
Yes
No
Each Value
1
No

There are 3 Sections grouped under the same section header and one is a text
control which is not displaying all the text available in the database (which
is a memo)

I have the following attributes for the text controls (Properties: All)
Test Description Header
None
None
No
Yes
Yes
Yes
No
0.2813"
1677715
Flat
Blank
Blank
Blank
Blank

The result is the report show the text control displaying only 255 chracters
where the memo in the tables hold more chracters than the 255 I see.

Please help. I've already checked two books on Access 2003, plus trawled the
net and all the sections in this Access Discussion group.
 
Bluet00th said:
I need help in making the report show the whole text in the report. These
are the control attributes currently employed in my report.

Grouping & Sorting:
Yes
No
Each Value
1
No

There are 3 Sections grouped under the same section header and one is a text
control which is not displaying all the text available in the database (which
is a memo)

I have the following attributes for the text controls (Properties: All)
Test Description Header
None
None
No
Yes
Yes
Yes
No
0.2813"
1677715
Flat
Blank
Blank
Blank
Blank

The result is the report show the text control displaying only 255 chracters
where the memo in the tables hold more chracters than the 255 I see.
Click to expand...


While it's nice that you posted the control's property
settings, you should provide the name of each property along
with its value. I can't be sure, but I think you do have
CanGrow set to Yes, so let's proceed assuming that's not the
issue.

The first thing to check is that you have nothing in the
text box's Format property (formatting a memo field is one
reason for the field to me truncated).

Other reasons for truncation all lie in the report's record
source query. Using the DISTINCT predicate, using the memo
field in a GROUP BY clause and using UNION are the most
common causes. If this doesn't straighten it out, post a
Xopy/Paste of the query's SQL statement and we'll try to
spot the problem.
 
If you are sorting, grouping, or calculating on a memo field in your query or
report it will truncate to 255 characters. I have not tried this but you
might get away with a calculated field in your query of =[your memo field]
which will be truncated to 255 but (hopefully) will leave your memo field
intact. Use the calculated field in your grouping / sorting and display your
actual memo field.

HTH

Terry
 
Yes Marshall you are right.

SELECT [Headset Properties].Name, [Test Types].[Test Chapter], [Test
Types].[Test Description], Results.[Test Result], Results.[Test Remark],
[Test Types].[Test Type], [Phone Properties].[Phone Name]
FROM [Phone Properties] INNER JOIN ([Test Types] INNER JOIN ([Headset
Properties] INNER JOIN Results ON [Headset Properties].[HS ID] = Results.[HS
ID]) ON [Test Types].[Tests ID] = Results.[Tests ID]) ON [Phone
Properties].[Phone ID] = Results.[Phone ID]
WHERE ((([Headset Properties].Name)="Medusa 16"))
GROUP BY [Headset Properties].Name, [Test Types].[Test Chapter], [Test
Types].[Test Description], Results.[Test Result], Results.[Test Remark],
[Test Types].[Test Type], [Phone Properties].[Phone Name]
ORDER BY [Headset Properties].Name, [Test Types].[Test Chapter], [Test
Types].[Test Description], Results.[Test Result], Results.[Test Remark],
[Test Types].[Test Type], [Phone Properties].[Phone Name];

Its a Group By.

If I remove the group by settings, the report doesn't show.
So how can I still see the report? So what must I put in the TOTALs field
for "[Test Types].[Test Type], ".

Thanks.
 
Hi Terry,

Yes the table is "GROUP BY". If I remove the grouping, I report cannot be
seen, how can I get around this problem.

Thanks once again.
--
Bluet00th



TerryC said:
If you are sorting, grouping, or calculating on a memo field in your query or
report it will truncate to 255 characters. I have not tried this but you
might get away with a calculated field in your query of =[your memo field]
which will be truncated to 255 but (hopefully) will leave your memo field
intact. Use the calculated field in your grouping / sorting and display your
actual memo field.

HTH

Terry

Bluet00th said:
Hi,
I need help in making the report show the whole text in the report. These
are the control attributes currently employed in my report.

Grouping & Sorting:
Yes
No
Each Value
1
No

There are 3 Sections grouped under the same section header and one is a text
control which is not displaying all the text available in the database (which
is a memo)

I have the following attributes for the text controls (Properties: All)
Test Description Header
None
None
No
Yes
Yes
Yes
No
0.2813"
1677715
Flat
Blank
Blank
Blank
Blank

The result is the report show the text control displaying only 255 chracters
where the memo in the tables hold more chracters than the 255 I see.

Please help. I've already checked two books on Access 2003, plus trawled the
net and all the sections in this Access Discussion group.
Click to expand...
Click to expand...
 
You may be able to get what you want by setting Results.[Test Remark] to
FIRST vice GROUP BY.

Assuming you use the query grid, just change the GROUP BY under [Test
Remark] to FIRST. This will pick one of the REMARKs for the grouped items.
I am assuming the Test Remark is the Memo field you are referring to in your
post here and in the other thread you have open with me.


Bluet00th said:
Yes Marshall you are right.

SELECT [Headset Properties].Name, [Test Types].[Test Chapter], [Test
Types].[Test Description], Results.[Test Result], Results.[Test Remark],
[Test Types].[Test Type], [Phone Properties].[Phone Name]
FROM [Phone Properties] INNER JOIN ([Test Types] INNER JOIN ([Headset
Properties] INNER JOIN Results ON [Headset Properties].[HS ID] =
Results.[HS
ID]) ON [Test Types].[Tests ID] = Results.[Tests ID]) ON [Phone
Properties].[Phone ID] = Results.[Phone ID]
WHERE ((([Headset Properties].Name)="Medusa 16"))
GROUP BY [Headset Properties].Name, [Test Types].[Test Chapter], [Test
Types].[Test Description], Results.[Test Result], Results.[Test Remark],
[Test Types].[Test Type], [Phone Properties].[Phone Name]
ORDER BY [Headset Properties].Name, [Test Types].[Test Chapter], [Test
Types].[Test Description], Results.[Test Result], Results.[Test Remark],
[Test Types].[Test Type], [Phone Properties].[Phone Name];

Its a Group By.

If I remove the group by settings, the report doesn't show.
So how can I still see the report? So what must I put in the TOTALs field
for "[Test Types].[Test Type], ".

Thanks.
--
Bluet00th



Marshall Barton said:
While it's nice that you posted the control's property
settings, you should provide the name of each property along
with its value. I can't be sure, but I think you do have
CanGrow set to Yes, so let's proceed assuming that's not the
issue.

The first thing to check is that you have nothing in the
text box's Format property (formatting a memo field is one
reason for the field to me truncated).

Other reasons for truncation all lie in the report's record
source query. Using the DISTINCT predicate, using the memo
field in a GROUP BY clause and using UNION are the most
common causes. If this doesn't straighten it out, post a
Xopy/Paste of the query's SQL statement and we'll try to
spot the problem.
Click to expand...
Click to expand...
 
Bluet00th said:
Yes Marshall you are right.

SELECT [Headset Properties].Name, [Test Types].[Test Chapter], [Test
Types].[Test Description], Results.[Test Result], Results.[Test Remark],
[Test Types].[Test Type], [Phone Properties].[Phone Name]
FROM [Phone Properties] INNER JOIN ([Test Types] INNER JOIN ([Headset
Properties] INNER JOIN Results ON [Headset Properties].[HS ID] = Results.[HS
ID]) ON [Test Types].[Tests ID] = Results.[Tests ID]) ON [Phone
Properties].[Phone ID] = Results.[Phone ID]
WHERE ((([Headset Properties].Name)="Medusa 16"))
GROUP BY [Headset Properties].Name, [Test Types].[Test Chapter], [Test
Types].[Test Description], Results.[Test Result], Results.[Test Remark],
[Test Types].[Test Type], [Phone Properties].[Phone Name]
ORDER BY [Headset Properties].Name, [Test Types].[Test Chapter], [Test
Types].[Test Description], Results.[Test Result], Results.[Test Remark],
[Test Types].[Test Type], [Phone Properties].[Phone Name];

Its a Group By.

If I remove the group by settings, the report doesn't show.
So how can I still see the report? So what must I put in the TOTALs field
for "[Test Types].[Test Type], ".
Click to expand...


Why is it a Totals type query?? You are not calculating any
totals, so making it a Totals type query doesn't accomplish
anything except removing duplicate lines (the same thing
that DISTINCT does). Is that really what this is for?

I can not imagine why making this a standard SELECT query
instead of a Totals query would cause the report to bomb.
Try turning the Totals line off (View menu).
 
Hi John & Marshall,

Thanks so much. Problem solved. I removed all the Group By from the TOTALs
and the report generated just fine.

Thank you so much for your help
--
Bluet00th


Marshall Barton said:
Bluet00th said:
Yes Marshall you are right.

SELECT [Headset Properties].Name, [Test Types].[Test Chapter], [Test
Types].[Test Description], Results.[Test Result], Results.[Test Remark],
[Test Types].[Test Type], [Phone Properties].[Phone Name]
FROM [Phone Properties] INNER JOIN ([Test Types] INNER JOIN ([Headset
Properties] INNER JOIN Results ON [Headset Properties].[HS ID] = Results.[HS
ID]) ON [Test Types].[Tests ID] = Results.[Tests ID]) ON [Phone
Properties].[Phone ID] = Results.[Phone ID]
WHERE ((([Headset Properties].Name)="Medusa 16"))
GROUP BY [Headset Properties].Name, [Test Types].[Test Chapter], [Test
Types].[Test Description], Results.[Test Result], Results.[Test Remark],
[Test Types].[Test Type], [Phone Properties].[Phone Name]
ORDER BY [Headset Properties].Name, [Test Types].[Test Chapter], [Test
Types].[Test Description], Results.[Test Result], Results.[Test Remark],
[Test Types].[Test Type], [Phone Properties].[Phone Name];

Its a Group By.

If I remove the group by settings, the report doesn't show.
So how can I still see the report? So what must I put in the TOTALs field
for "[Test Types].[Test Type], ".
Click to expand...


Why is it a Totals type query?? You are not calculating any
totals, so making it a Totals type query doesn't accomplish
anything except removing duplicate lines (the same thing
that DISTINCT does). Is that really what this is for?

I can not imagine why making this a standard SELECT query
instead of a Totals query would cause the report to bomb.
Try turning the Totals line off (View menu).
Click to expand...
 
Back
Top