memo field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dcbrown428 - 03 Aug 2006 16:26 GMT

I thought I posted this, but can't find my posting so please forgive if this
is a duplicate. I have a field that I need to change from text to memo to
allow additional characters. I have gone in under table design and changed
it to memo, but it will still halt the characters at 255. What am I doing
wrong?

Reply to this Message

Ofer Cohen - 03 Aug 2006 16:49 GMT

The link to your previous post

http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public
.access.forms&mid=78c7df7b-204b-4a1b-9c6e-0872b21d098f

Signature

Good Luck
BS"D

> I thought I posted this, but can't find my posting so please forgive if this
> is a duplicate. I have a field that I need to change from text to memo to
> allow additional characters. I have gone in under table design and changed
> it to memo, but it will still halt the characters at 255. What am I doing
> wrong?

Reply to this Message

John Vinson - 03 Aug 2006 20:02 GMT

>I thought I posted this, but can't find my posting so please forgive if this
>is a duplicate. I have a field that I need to change from text to memo to
>allow additional characters. I have gone in under table design and changed
>it to memo, but it will still halt the characters at 255. What am I doing
>wrong?

I saw the post and replied to it so I'm not sure what's wrong!

Be sure that there is no Format or Input Mask defined for the field;
either will truncate it to 255 characters. Also, don't try to sort by
or group by the field in a query.

John W. Vinson[MVP]

Reply to this Message

Dcbrown428 - 03 Aug 2006 20:53 GMT

Thank you for your help!

> >I thought I posted this, but can't find my posting so please forgive if this
> >is a duplicate. I have a field that I need to change from text to memo to
[quoted text clipped - 9 lines]
>
> John W. Vinson[MVP]

Reply to this Message