memo field not working as one?

[russi]

Hi. Hope you can help.

I have a field that is defined as a memo field.

However, on the form, even though users can enter an indefinite amount of text, after they save the form and go back in, only some of what was entered is saved. It looks like maybe 250 characters worth.

Any ideas?

 

[BarkerD]

I have had this exact problem in the past.

It seems that Access treats a memo field as a text field in certain instances, like when formatting is applied to the memo field.

Try removing all formatting from the control.

Duane Barker

 

[bill crumpton]

If you set the memo field in the table to "Allow Zero Legnth" to YES that will fix your problem.


BAC