Text Area to a text field

[Spencer]

Hi,

I've got a form in which I want to allow input from that
form to a text field in a database. I used the text area
type of form field, so that the user can include
paragraphs, even if they have to be short ones.

The database field has to be a text field, because I do
queries on it, and querying a memo field generates
garbage in Access. But a text field can
recognize "carriage returns", so I want to use the text
area type field in the form.

But, when I use the text area, I get a type mismatch
between the form and the database field.

Does anybody know a way to get around this problem?
Thanks.