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~ 1 3622
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.publi c.access hierarchy.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"JA" <ja*****@kc.rr. comwrote in message
news:Xi******** *********@torna do.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~ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Bob Kaku |
last post by:
I'm trying to retrieve a text value from a MySQL database, put it into
an updateable form, allow edits, and send back the edited text back
into the MySQL database. I've been able to successfully retrieve the
text and put it into the editable form, using htmlspecialchars
function. But, I can't find a way of accepting the edited text and
sending back to the database.
Here's my code for retrieval.
<?php
|
by: Frances |
last post by:
at work we switched to UTF-16 encoding and now when I open html files in
HomeSite the code is all messed up, and if I turn on "enable non-ANSI
file encoding" code looks fine when I open files but I get this error
when I try to save them..
"The character set defined in your document does not match the
encoding format you selected in the Save As Dialog" (even though I
don't do Save As, just save..) and sometimes doesn't let me save them...
|
by: Trevor Best |
last post by:
When did this change? I thought is was 64K but I managed to dump 18MB in
one, Access crashed when I scrolled to the bottom (out of memory error
then sent report to MS). Out of interest, does anyone what a reasonable
limit is? i.e. how much text can be dumped and scrolled without crashing.
--
Pretentious? Moi?
|
by: JA |
last post by:
Why do I sometimes get the error "the text is too long to be edited" when
trying to work directly in a memo field in Access 2000?
Is there a way to make that go away?
Thanks, JA
|
by: Alexander |
last post by:
I am building a little unique dialog editor and have derived some new
classes like DButton, DLabel and DTextBox. The user adds these
Controls to a panel which is part of a class Document which is not a
control. The controls in the dialog can be edited with a PropertyGrid.
When the user closes the dialog he edited it was first disposed,
because it was not part of an Control anymore. I changed that by
overriding the Dispose function of the...
| |
by: Niraj via DotNetMonster.com |
last post by:
i had put a panel in form and text box,label and numericupdown control in it.
Now i had use to send the form as me to some function byref then again from
that particular function i use to send the me as f to another function to
check some text box which are in pane control.
now when i try to check the values of text box if i had edited i dont get any
of the edited value to check bt i always get old values of textbox which are
in panel....
|
by: Tilo Pätzold |
last post by:
Hi Everybody (especially Microsoft),
we build EMF files with rotated text for export to office (powerpoint,
word). It is planned that the text can be edited in the office document.
Without the rotate transformation the text stays as a block and can be
edited in the office document after ungrouping. But a rotated text leads to
single charackters when ungrouping.
The following sample code creates an emf file. The file can be dragged to...
|
by: yang__lee |
last post by:
Hi,
I hope you may help me.
Please check the attached text file.
Actually its a report file with some headers information
and them report is in tabular format. I want to parse each row
and get the values.
I think strtok won't work here.
|
by: JosAH |
last post by:
Greetings,
Introduction
At the end of the last Compiler article part I stated that I wanted to write
about text processing. I had no idea what exactly to talk about; until my wife
commanded me to "clean up that mess you never use anyway and please dump the
rest of it in the attic or simply throw that junk away".
I want to make a statement here:
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |