Changing field type from Text to Memo..., any dangers ?

[Denniso6]

Hi all…,

I’m about to change a field type from Text to Memo because I find I’m
needing more character spaces that 255.

Are there any inherent dangers in doing this ?

Thanks in advance.

DennisO

 

[Maurice]

No, no danger the other way around could create 'clipping' text but in this
case you are fine.

hth

 

[John W. Vinson]

Hi all…,

I’m about to change a field type from Text to Memo because I find I’m
needing more character spaces that 255.

Are there any inherent dangers in doing this ?

Some cautions. You cannot Index a Memo field, or use it as a field in a
primary key; sorting by the field will sort only by the first 255 characters
and will be slower than sorting a text field; searching for values in the
field will be less efficient than searching a Text field (because it cannot be
indexed).

Memo fields are also slightly more prone to corruption than text.

By all means, use memo - but just be aware of the limitations.