Memo Field being cut-off on report.

[sorcerer11]

Hi,

I'm having a problem with a memo field which is being cut-off on a report after 255 charectors in Access 2002.

I've had a search around and it appears that other people are having the same problem, I couldn't find anything about this on the microsoft knowledgebase.

Does anybody know of a solution.

P.S. Can Grow and Can Shrink have no effect on this problem.

 

[smedvid]

I can not seem to reproduce this issue. I created a little table with a memo field, then used the report wizard and looks ok to me... Do u have more details?

Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[sorcerer11]

Hi Steve,

I've done some more investigates and it looks like the problem might come from the query. The report is based on a query, and the query seems to chop off the memo field at 255.

So try creating a query that uses your report and see what you get then.

 

[smedvid]

did already... query was fine...

Is the data source Access-2002? If not, are the queries pass-through?

Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[Garridon]

By chance, you aren't trying to export an Access report to Excel, are you? There is a known issue that causes exactly what you describe. If so, this is how to fix it, though it's pretty messy:

http://www.tek-tips.com/faqs.cfm?spid=703&sfid=2473

 

[sorcerer11]

Nope just a simple query based on another query, but it's ok because I've found another way around the problem. It just seemed to be a problem with this particular query, as to why it thought about only displaying the first 255 of a memo field I have no idea.

 

[CosmoKramer]

Are you applying any formatting to the query field?? If so, try removing it....

http://support.microsoft.com/default.aspx?scid=kb;en-us;103998

 

[sorcerer11]

Nope no formatting, but their was another similiar post in that somebody found the soultion by removing the group by in the query, whilst I simply created a new query which was defined in a slighly different way to get round the problem.

But it does seem to be some sort of bug.

 

[dhookom]

Your query can't contain words like "DISTINCT" or "GROUP BY". If you share your sql, we might be able to find the cause.

Duane
MS Access MVP