memo field on report

[abezuide]

Hi,
I have a field in a table that is of size memo. On my report I pick a textbox to display the field in, yet, it insists on showing only 255 characters. How do I display the whole memo field?

Thanks

 

[abezuide]

oh yes, and the field property "can grow" is set to yes. I have tried to set the can shrink property off as someone suggested but it keeps cutting off the stuff at 255 characters!!!!!
Thanks for any suggestions

 

[WayneRyan]

a,

Somewhere in the process something has taken on the attributes of
a text field with a maximum of 255 characters.

I can't make it do what you are seeing. Can you post a sample?

Tools --> Database Utilities --> Compact/Repair
Then ZIP
Then attach

Wayne

 

[abezuide]

Hi Wayne,
I have now realized that it is my query on the report that is truncating the data somehow. It is a very complex query with parameters and 3 unions. I also create an external database on the fly and create a table in which I export the data of this union query. Sure enough the data in the table in the new database is also truncated. It seems to only happen when you do a union query. Unfortunately I do need all 3 parts of the union, but I also need all my data to display
Not sure if I can make myself understood