Long Text Field Getting Cut Off In Report

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Long Text Field Getting Cut Off In Report

Post by Leesha »

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
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Long Text Field Getting Cut Off In Report

Post by HansV »

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.
Best wishes,
Hans

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Re: Long Text Field Getting Cut Off In Report

Post by Leesha »

Wow! That is so good to know. I always wondered what the distinct stood for / did.
Thanks Hans!
Leesha