crosstab query

[Diem]

Hi all,

Its my first time using this forum! I'd appreciate some help with an issue with crosstab query.

I have created a crosstab query based on another query. One of the expression in the crosstab query doesn't return the full size of the original field (ie. half of the text has been cut off). The original field is a memo type but I know that expressions don't neccessarily preserve the data type of the original fields.

I don't know if it's a data type problem or a field size problem (?).How to overcome this?

Thanks
Diem

 

[Jon K]

When a query is run, it is not possible for the query to display the whole contents of a memo field in datasheet view.

Try creating a report or form to see if the memo contents can be displayed in full.

 

[Diem]

Hi Jon,

Thanks for your reply. I actually had a report created for that particular query. Unfortunately, it's exactly the same as in the crosstab query (I've also used the "Can Grow" property of the report field).

Any idea?
Diem