Memo field length and queries (1 Viewer)

[HowieZ]

Hi Everyone,

I have a form with bound controls where I dynamically change the
recordsource via an SQL query based upon the user's input. One of
the bound fields on the form is a memo data type field which is now
cutting off the data at 255 characters within the field.

Any suggestions? Is there any way around this limitation?

Thanks in advance,

Howard

 

[DML]

Not that I am questioning you...just trying to make sure...

In the table, the data is actually now only 255 characters? If this is the case, are you doing an update or append query?

Or on the form, only 255 characters are being displayed. If this is the case, are you sure the other characters aren't there? Are your scroll bars on the field set to Vertical?

 

[HowieZ]

On the form when you tab out of the field memo field, because the field is bound to a query, the data in the memo field is truncated after 255 characters.

If the form is bound to a table, it works fine.