|
|
Posted by Dan Guzman on 10/10/06 12:38
I don't know much about Access but I suspect you are trying to edit data via
an Access form or grid. Since the problem occurs when you attempt edit some
existing rows but not others and occurs with both Access and SQL Server
databases, it looks to me like there is some built-in Access data length
restriction.
Your best bet for this question is one of the groups in the
microsoft.public.access hierarchy.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"JA" <jarmour@kc.rr.com> wrote in message
news:XiDWg.2418$IO2.1259@tornado.rdc-kc.rr.com...
> Hi,
>
> I asked this in an MS Access newsgroup, but no one has answered. Since it
> also applies to SQL Server, maybe someone in here has an answer? I
> actually do have the same problem in both SQL Server 2000 and Access 2000.
>
> When I click in certain records in a memo field, I get the error message
> "text too long to be edited", and I can't get into the record to make any
> changes.
>
> I tried exporting the record to html, but only part of the memo field is
> exported.
>
> I know that in SQL Server, you can increase the size of the field, but you
> can't do that in an Access memo field (that I know of!).
>
> I'm thinking that if I could get into the field and lose some of the white
> space, it would help, but I can't get into the field, and can't get the
> data out, either!
>
> Does anyone know anything about this?
>
> Thanks, Jill~
>
>
>
Navigation:
[Reply to this message]
|