I did even worse, I went into Access, opened the design of a table, saw that my character type fields are formatted "text" so opted for "text."

I have to admit though, it was worth it. I now have a much better understanding of the difference between text and varchar in SQL and memo and text in Access.