My Memo fields only accept 255 characters - Why

My Memo fields only accept 255 characters - Why - they are memo f.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cam Edge - 31 Dec 2004 20:01 GMT

I have a memo field in a database, and when I add more than 255 characters
they go in and soon as I do something else the characters over 255 disappear
from the field. The first 255 stay there but the rest are gone. Is there an
explanation for this please?

Regards

Cam Edge

Reply to this Message

Duane Hookom - 31 Dec 2004 20:51 GMT

Do you have a value in the Format property of the text box?

Signature

Duane Hookom
MS Access MVP

>I have a memo field in a database, and when I add more than 255 characters
> they go in and soon as I do something else the characters over 255
[quoted text clipped - 6 lines]
>
> Cam Edge

Reply to this Message

Cam Edge - 31 Dec 2004 21:21 GMT

Yes it has the > for all caps in it.

Cam

> Do you have a value in the Format property of the text box?
>
[quoted text clipped - 8 lines]
> >
> > Cam Edge

Reply to this Message

Duane Hookom - 31 Dec 2004 22:13 GMT

Remove it. Formats will not allow displaying more than 255 characters.
Besides ALL CAPS IS SO DIFFICULT TO READ!

Signature

Duane Hookom
MS Access MVP

> Yes it has the > for all caps in it.
>
[quoted text clipped - 14 lines]
>> >
>> > Cam Edge

Reply to this Message