A report cuts off long memo fields 2

[Katya85S]

There are 2 memo fields displayed in the report. Fields are located one under another, for the whole length of a page. My customer says, that when she prints the report, those fields cuts information longer then 2 lines, so just the first 2 lines are printed of each field and the rest of the information gets chopped off. When i print the report from my computer (the report is located on shared drive and is accessible to more then one person) all the information prints in full. How can I fix this problem for her?
Thank you all in advance.

 

[Trevil]

On HER computer, open the report in design view.

1. Does the SECTION Can Grow property = Yes
2. Does the Fiels(s) Can Grow property = Yes

Learn from the mistakes of others. You won't live long enough to make all of them yourself.

 

[Katya85S]

Trevil, thank you very much!

 

[Katya85S]

Ooops... My client checked Can Grow Properties for the section and the fields on her computer. The Can Grow property says "Yes". So the problem is in something else. What could it be? any idea?

 

[Trevil]

Is there any value specified in the fields "Format" property?

As a test I did the following:
1. Set Section & Control "Can Grow" to NO; result = truncation
2. Set Control "Can Grow" to Yes; result = truncation
3. Set Section "Can Grow" to Yes; result = NO TRUNCATION
4. Set "Format" to "AAAAAAAAAAAAA"; result = truncation (after 11 lines).

I realize you said "when I / she PRINTS", but what happens in PREVIEW mode?

Not sure, but print properties the same between your workstation and hers?



Learn from the mistakes of others. You won't live long enough to make all of them yourself.

 

[Katya85S]

When we view the report from the screen i could see all the data in those fields on my computer and she sees the data truncated on her computer.

 

[Trevil]

I'll bet there are only 256 characters being displayed?

We are dealing with MS-Access -- right? (Excel is a different story)

Also, can you confirm there is NO FORMAT property?

Try looking at the query (I assume it's getting the data from an Access database?) Does the query return the fulll set of data on her computer?

Learn from the mistakes of others. You won't live long enough to make all of them yourself.

 

[Katya85S]

Trevil, thanks again for your replay.
Yes, we are talking about MS Access database. The database uses linked SQL Server tables. In SQL Server database those fields are of type ntext.

The MS Access Qyery (a record source of the report) does not display the full set of data for those fields on my computer either, although i get the full set of data in the report.
And, yes, there is NO Format property.
I'm not sure how i can check if the displayed number of characters is 256 (if that was your question).

 

[Trevil]

Backtracking from the report field, open the table that contains the field that is being truncated. Is it's TYPE = "Text"? If so, then you are limited to 256 characters in Access -- regardless of what may be in SQL Server.

If the type is TEXT, then can you count the number of characters being displayed on "her" report? If it's < 256, then you willl need to change the field TYPE in Access to "MEMO".



Learn from the mistakes of others. You won't live long enough to make all of them yourself.

 

[Katya85S]

Yes, the fields are MEMO, I have mentioned it on my first note. On "her" computer the fields read MEMO as well. Do you think we still have to count the number of the displayed characters?

 

[Katya85S]

I found what causes the problem. She has different screen resolution. Mine is 1024x768 and hers is 800x600 pixels. When i've changed mine to hers numbers my "memo" fields in the report came out truncated as well.
I guess i could ask my client to change screen resolution when she has to run the report, but i hope there is some more reasonable solution to solve the problem without interfering with customer’s preferences.

 

[dhookom]

Having different screen resolutions will never have an effect on how many characters are returned in a column in a query. Having a query with phrases such as "DISTINCT", "DISTINCTROW", "GROUP BY",... will limit the number of characters in a memo field to 255.

If you can figure this out, come back here with the SQL view of the record source of your report. If you have queries based on other queries, you may need to provide us with the SQL of the other queries.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Katya85S]

yes, i just deleted the Group BY from the query and the problem seem to be fixed. I still don't understand why Grou By did not affect the way data was displayed on my computer, but affected teh reprot on hers?
Thank you very much dhookom!

 

[dhookom]

You probably have different versions of DAO.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Katya85S]

I see. Thank you.