Hi,
I've got a form based on a query. One of the fields on the form is restricted to 255 characters, now that field is a memo field in the table underlying the query, so holds more than 255 characters.
Add to this that, I have a similar query using the exact same tables, yet on the form based on that query, the whole text is there. The only thing different on each query is that there is criteria on the one with the problem.
I imagine I've just missed something in the properties, but I can't think what. Any tips/help much appreciated!
I've got a form based on a query. One of the fields on the form is restricted to 255 characters, now that field is a memo field in the table underlying the query, so holds more than 255 characters.
Add to this that, I have a similar query using the exact same tables, yet on the form based on that query, the whole text is there. The only thing different on each query is that there is criteria on the one with the problem.
I imagine I've just missed something in the properties, but I can't think what. Any tips/help much appreciated!