memo field through intermediate forms

[betwalk]

Hi-

I use unbound intermediate forms to enter and edit data. When I am
satisfied with data, I use update queries to write the data to my
table(s). I have discovered that if I write more than 500 words to a
"comments" field, which is a memo data type, the data sort of fractures
right around the 500th keystroke. I know that memo fields can hold
much more text than this, when I test with a bound form, I can type
away to my heart's content in that field and the data is stored, of
course, as I move from the record. When I return to that record, the
data is fine. However, I cannot use bound forms. I can type as much
as I want in the "comments" control in my unbound form, but when I save
the addition or the edit and then return to view my data, it is not
fine.

Is the problem with the control on the intermediate form? I suspect
so... Or is it the query, through which the data is passed to the
table? Or a combination? I've looked at the properties of the control
on the intermediate form and do not see a way for me to instruct Access
that this is a memo data type. But it's not blocking me as if it were
just a text field. Then I'd be cut off at about 256 keystrokes.

Thanks for any/all suggestions!

Betsy

 

[betwalk]

"comments" field, which is a memo data type, the data sort of fractures
right around the 500th keystroke.

------------------------------------------
Sorry for the conflicted statement here. It is keystrokes I'm
counting, not words.

Looking in Access 2003 help, I see that specifications for Access forms
and reorts, the content of any form's plain text box should be 65,535
keystrokes. That's sure a far cry from 500 keystrokes.

What might I have done wrong here? I've added no special formatting or
properties to these unbound fields...

Betsy