Text Cut Off 
Author Message
 Text Cut Off

I have a text box in my report that is being cut off. It
is a Memo field and not all the text is showing up. Can
Grow is selected both in the text box properies and the
detail form properties. Is there something else I should
do?


Sun, 10 Oct 2004 05:04:25 GMT  
 Text Cut Off
Open the Record Source directly and see if the field is truncated there (I
expect it is). This would suggest that you have a group by or distinct or
something else in the query that causes this.

If you can't resolve this, copy the SQL from your recordsource to the body
of a message so we can have a look.

--
Duane Hookom
Microsoft Access MVP
Please direct any questions to News Groups


Quote:
> I have a text box in my report that is being cut off. It
> is a Memo field and not all the text is showing up. Can
> Grow is selected both in the text box properies and the
> detail form properties. Is there something else I should
> do?



Sun, 10 Oct 2004 05:54:13 GMT  
 Text Cut Off
ORIGINAL QUESTION:  I have a text box in my report that is
being cut off. It is a Memo field and not all the text is
showing up. Can Grow is selected both in the text box
properies and the detail form properties. Is there
something else I should do?

ANSWER:
Open the Record Source directly and see if the field is
truncated there (I
expect it is). This would suggest that you have a group by
or distinct or
something else in the query that causes this.

If you can't resolve this, copy the SQL from your
recordsource to the body
of a message so we can have a look.

SQL STATEMENT:NOTE: I HAVE A SUBQUERY, MAYBE THAT IS THE
PROBLEM.

SELECT ST.Insured, ST.[Status Date], ST.Status,
Insured.Attorney, Insured.[Date Last Reviewed],
Insured.Significant
FROM Status AS ST INNER JOIN Insured ON ST.Insured =
Insured.Insured
GROUP BY ST.Insured, ST.[Status Date], ST.Status,
Insured.Attorney, Insured.[Date Last Reviewed],
Insured.Significant
       HAVING (((ST.[Status Date])=
               (SELECT MAX ([Status Date])            
       FROM Status ST1  
       WHERE ST.[Insured] = ST1.[Insured]))
AND             ((Insured.Significant)=True))
ORDER BY ST.Insured;



Sun, 10 Oct 2004 07:41:53 GMT  
 Text Cut Off
You would need to get rid of the "Group By".

--
Duane Hookom
Microsoft Access MVP


Quote:
> ORIGINAL QUESTION:  I have a text box in my report that is
> being cut off. It is a Memo field and not all the text is
> showing up. Can Grow is selected both in the text box
> properies and the detail form properties. Is there
> something else I should do?

> ANSWER:
> Open the Record Source directly and see if the field is
> truncated there (I
> expect it is). This would suggest that you have a group by
> or distinct or
> something else in the query that causes this.

> If you can't resolve this, copy the SQL from your
> recordsource to the body
> of a message so we can have a look.

> SQL STATEMENT:NOTE: I HAVE A SUBQUERY, MAYBE THAT IS THE
> PROBLEM.

> SELECT ST.Insured, ST.[Status Date], ST.Status,
> Insured.Attorney, Insured.[Date Last Reviewed],
> Insured.Significant
> FROM Status AS ST INNER JOIN Insured ON ST.Insured =
> Insured.Insured
> GROUP BY ST.Insured, ST.[Status Date], ST.Status,
> Insured.Attorney, Insured.[Date Last Reviewed],
> Insured.Significant
>        HAVING (((ST.[Status Date])=
>                (SELECT MAX ([Status Date])
>        FROM Status ST1
>        WHERE ST.[Insured] = ST1.[Insured]))
> AND             ((Insured.Significant)=True))
> ORDER BY ST.Insured;



Sun, 10 Oct 2004 11:32:27 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Printing plain-text cuts off message

2. Solution for text cut-off problem

3. Text cut off, doesn't wrap

4. wrapped text cut off

5. Email text cut off half way down the page

6. Text cut off

7. Text cut off

8. Text cut off

9. Text cut off

10. All text cut off at 6"


 
Powered by phpBB® Forum Software © phpBB Group