Hi,
I have a report called rptAffirmationCardsScripture. The report contains srptAffirmations. srptAffirmations has a field [Scripture] which is set to Long Text in tblPathway-Edited. The information in the table is correct. The issue is that it gets cut off in the qryClientAffirmationReport. As a result it gets cut off in the report. I am not sure what to do so that [scripture] doesn’t get cut off.
Thanks!
Leesha
Long Text Field Getting Cut Off In Report
-
- BronzeLounger
- Posts: 1488
- Joined: 05 Feb 2010, 22:25
Long Text Field Getting Cut Off In Report
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78558
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Long Text Field Getting Cut Off In Report
It's caused by the query that acts as Record Source of the subreport. Its SQL starts with SELECT DISTINCT.
The keyword DISTINCT causes records to group, and that causes long text fields to be truncated to 255 characters.
If you remove the word DISTINCT, the text won't be cut off.
The keyword DISTINCT causes records to group, and that causes long text fields to be truncated to 255 characters.
If you remove the word DISTINCT, the text won't be cut off.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1488
- Joined: 05 Feb 2010, 22:25
Re: Long Text Field Getting Cut Off In Report
Wow! That is so good to know. I always wondered what the distinct stood for / did.
Thanks Hans!
Leesha
Thanks Hans!
Leesha