>Hi
>Can anyone help me how can programmatically change a field type from memo to character
>thanks
>bill

Bill,

To add to the other suggestions, make sure you follow J.Crescencio's advice and do a backup just in case your memo fields are larger than the character field's length limit. When you change to character it may truncate your data.

Renoir