characters in memo field

[Guest]

I have a field in table with a data type of memo. How do I display all the
text in that field on a form? The form only displays 255 chars.

Jane

 

[Van T. Dinh]

I don't think it is the problem with the TextBox Control on the Form since a
TextBox can display 64K characters.

More likely, the problem is in the RecordSource of the Form. For example if
the RecordSource is a Query that uses Domain Aggrgate function such as
"GROUP BY", Access / JET needs to compare the (Text) values to group. To do
this, JET needs to truncate Memo Field values to 255 characters before it
can compare the different values of the Memo Field.

 

[Guest]

My Record Source is the underlying table name - nothing else.

Any other ideas?

Jane

 

[Brett Collings [429338]]

Yup, a few.
- Check the table again and confirm the data type IS Memo
- Clear all Formats from the Control
- Check the status of the CanGrow property, it shouldn't affect a Memo
field, but hey we're getting desperate at this point
- If all else fails,
- delete the control from the form
- Compact and Repair the database
- Add the control back into the form

Essentially if the field is Memo Type in the table and the forms
Recordsource is the table, it should display all 64k of characters.

Brett