469,618 Members | 2,578 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,618 developers. It's quick & easy.

How to change text to memo

Hi all,

I want to change a field data type from Text to Memo.The reason is I
need to type more text in that field.

when I was saving the change I got error message "The width of a
Unicode text column must be an even number of bytes." Could some one
tell me what I can do with this message and how I can change the
existing text field to memo field?

Thanks In Advance !!!
Jan 30 '08 #1
1 3981
On Wed, 30 Jan 2008 08:40:32 -0800 (PST), ba**********@yahoo.com
wrote:

That is a curious message. Are you sure Unicode Compression is on?

An alternative might be to first create an additional field for the
memo data, then write an Update query to set its value to that of the
Text field, then delete the Text field and rename the Memo field.

-Tom.
>Hi all,

I want to change a field data type from Text to Memo.The reason is I
need to type more text in that field.

when I was saving the change I got error message "The width of a
Unicode text column must be an even number of bytes." Could some one
tell me what I can do with this message and how I can change the
existing text field to memo field?

Thanks In Advance !!!
Jan 31 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Dalan | last post: by
4 posts views Thread by Art | last post: by
reply views Thread by Ennio-Sr | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.