I tried to add a field with Text field. following is my code

mSQL = "alter table prod add fName Text"
cn.execute(mSQL)

It runs ok, but it didn't give Text Field as a data type when I checked db. It gave me a 'Memo' data type. Please tell me why and how to fix it. I tried 'Number' and 'Date'. they were all ok.

Thanks in Advance.