How to prevent Remarks from truncated (1 Viewer)

luzz · Oct 11, 2017

Hi guys, I am facing issue whereby part of my remarks are being cut off in my report even though i have change my data type to long text. How can I fix this issue?

moke123 · Oct 11, 2017

Any of this apply? http://allenbrowne.com/ser-63.html

luzz · Oct 11, 2017

moke123 said:
Any of this apply? http://allenbrowne.com/ser-63.html

Only the first one apply and i have tried it, it does not work

JHB · Oct 11, 2017

How does the record source for the report look like, does it have all the text shown in picture 1?

luzz · Oct 11, 2017

JHB said:
How does the record source for the report look like, does it have all the text shown in picture 1?

I have textbox for remarks in my report which cut short my whole remarks.

The remarks is also cut short on my query which i used it as my control source.

JHB · Oct 11, 2017

Then the problem is in the query, show the SQL-string for the query.

luzz · Oct 11, 2017

JHB said:
Then the problem is in the query, show the SQL-string for the query.

I have attached a image of my SQL query

JHB · Oct 11, 2017

The problem is you've the Remarks under Group By, so change the Remarks in the query to:

Code:

 ..., First(mxd.Remarks) AS Remarks, ...

moke123 send you a link where the problem is described and how it is solved.

luzz · Oct 11, 2017

JHB said:
The problem is you've the Remarks under Group By, so change the Remarks in the query to:

Code:

..., First(mxd.Remarks) AS Remarks, ...

moke123 send you a link where the problem is described and how it is solved.

Thank you! It works!

How to prevent Remarks from truncated (1 Viewer)

luzz

Registered User.

Attachments

moke123

AWF VIP

luzz

Registered User.

JHB

Have been here a while

luzz

Registered User.

Attachments

JHB

Have been here a while

luzz

Registered User.

Attachments

JHB

Have been here a while

luzz

Registered User.

Similar threads

Users who are viewing this thread