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

You can use Alter Table - Alter Column for that:

Alter Table myTable Alter Column myField c(20)

Although if you have data inside the memo field you might want to save it to do some further processing to prevent losing any data.