C
Casey
I am using ADO in Word 2002 to update a Memo field in an
Access 2002 database. I also have a Data Access Page
which reads the data. When hard returns are saved in the
database, they show up as squares and some chars that you
can't see. They display properly in the DAP, but if the
user in any way sets the focus to one of the bound
textboxes (i.e., clicking on it); the following error
appears:
"A value could not be saved into the datasource's
<fieldname> field. The Operation was cancelled."
If I strip out all of the hard returns in the database the
problem goes away.
There is a KB article # 295213 that talks about the error,
but only for evaluated expressions.
Please help.
:struggling way past my deadline!:
Access 2002 database. I also have a Data Access Page
which reads the data. When hard returns are saved in the
database, they show up as squares and some chars that you
can't see. They display properly in the DAP, but if the
user in any way sets the focus to one of the bound
textboxes (i.e., clicking on it); the following error
appears:
"A value could not be saved into the datasource's
<fieldname> field. The Operation was cancelled."
If I strip out all of the hard returns in the database the
problem goes away.
There is a KB article # 295213 that talks about the error,
but only for evaluated expressions.
Please help.
:struggling way past my deadline!: