C
C Naughton via AccessMonster.com
Hi. Access 97 scenerio: I have a form that includes 2 memo fields. I have
an append query that draws from the form and appends the memo fields into a
table, via a command button (on click). It will not append more than 255
characters from either memo field. If there's 256 characters, I get a
message "The size of a field is too long". If there's 257 or more, I get a
message "...can't run the query; the parameter values are too
large.....cannot exceed 1,024 characters." If less than 256, all is well.
I'm wondering if appending memos is simply not possible for memo records
above 255 characters.
The only solution I can figure is to skip the append and make my form Data
Entry = Yes...and have the table as its record source, thus typing directly
into the table. Any help?
an append query that draws from the form and appends the memo fields into a
table, via a command button (on click). It will not append more than 255
characters from either memo field. If there's 256 characters, I get a
message "The size of a field is too long". If there's 257 or more, I get a
message "...can't run the query; the parameter values are too
large.....cannot exceed 1,024 characters." If less than 256, all is well.
I'm wondering if appending memos is simply not possible for memo records
above 255 characters.
The only solution I can figure is to skip the append and make my form Data
Entry = Yes...and have the table as its record source, thus typing directly
into the table. Any help?