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 !!!

Re: How to change text to memo

On Wed, 30 Jan 2008 08:40:32 -0800 (PST), barbara_dave@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 !!!