Fields with 255+ characters blank on report

[nsomaiya]

Im trying to generate a report and have noticed that fields with 255 + characters are not populating on the report. What can I do resolve this? Thanks

 

[cheiboy]

Try making the field from a text to a memo. It is my understanding that memo fields are limited to 64,000 characters.

 

[nsomaiya]

It is a memo field, but doesn't work. Any other ideas?

 

[cheiboy]

Maybe, this might work. In the design view of your report, go to the properties and change all the can grow properties to 'yes'.

 

[nsomaiya]

The can grow was already set to yes. Any other ideas. Thanks for your help

 

[CosmoKramer]

If there is any formatting applied to these controls (such as > for uppercase, etc.), remove the formatting.

 

[nsomaiya]

We havent used any formatting either. Is there a way I can break up the fields and combine them in the report using strings?

 

[BobJacksonNCI]

What is your environment?

I have Access 2000 and create a report with a memo field without grief.

 

[nsomaiya]

Its Access 2000.

 

[BobJacksonNCI]

Since I didn't have to do anything special to make my report work... And, since the usually VERY helpful folk here haven't resolved this...

I suspect there are some special characters in your memo field causing the grief. To see if this is the problem, create a new table with the same characteristics. Then, copy a few records without the memo field to the new table. Next, copy/paste special a memo field at a time to notepad/wordpad/word - be sure to save as plain text. Then copy the plain text to the memo field in your new table. Run your report based on the new table and see if the result is different.

If I'm right, then you may need a VBA routine to cleanse your memo fields. There are many people contributing here who are more adept at helping putting that together.

Good Luck!
Bob (M.E.A.N.)
Moderately Exasperated Access Novice ;-)

 

[CosmoKramer]

I agree with Bob. I've gotten memo fields to display properly by ensuring the properties mentioned above were defined correctly.

One workaround you might want to try, if the criteria of your report is not too complicated, is to display the memo field in an unbound text box. Use a DLookup function as the control's ControlSource. If the key criteria field(s) is/are not currently on the report, you may have to add them as invisible controls....