Access memo field issue

[bunman]

I have a couple subforms within a main form for which all have a couple memo
fields. I'm only getting 255 characters input when I should get over 26,000.
I've looked at everything, so i think. Can anyone help resolve this issue?

 

[Dirk Goldgar]

I have a couple subforms within a main form for which all have a couple
memo
fields. I'm only getting 255 characters input when I should get over
26,000.
I've looked at everything, so i think. Can anyone help resolve this issue?

Do you apply any Format property to the field or control? Is the subform's
recordsource query a Totals query, or does it specify the DISTINCT keyword?

 

[bunman]

Do you apply any Format property to the field or control? Is the subform's
recordsource query a Totals query, or does it specify the DISTINCT keyword?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

I believe my problem is that my forms are based on tables rather than
queries. I thank you all for your responses but am pressed for time now. I
will have to look into that resolve at a later time.

 

[Dirk Goldgar]

I believe my problem is that my forms are based on tables rather than
queries. I thank you all for your responses but am pressed for time now. I
will have to look into that resolve at a later time.

Having your forms based on tables should be totally irrelevant to this
issue, except that some of the possible causes only come up when the form is
based on a query.