Hi all,
I want to change a field data type from Text to Memo.The reason is I
need to type more text in that field.
when I was saving the change I got error message "The width of a
Unicode text column must be an even number of bytes." Could some one
tell me what I can do with this message and how I can change the
existing text field to memo field?
Thanks In Advance !!!
1  4373 
On Wed, 30 Jan 2008 08:40:32 -0800 (PST), ba**********@ya hoo.com
wrote:
That is a curious message. Are you sure Unicode Compression is on?
An alternative might be to first create an additional field for the
memo data, then write an Update query to set its value to that of the
Text field, then delete the Text field and rename the Memo field.
-Tom.
>Hi all,
I want to change a field data type from Text to Memo.The reason is I
need to type more text in that field.
when I was saving the change I got error message "The width of a
Unicode text column must be an even number of bytes." Could some one
tell me what I can do with this message and how I can change the
existing text field to memo field?
Thanks In Advance !!!
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Alfredo Agosti |
last post by:
Hi folks,
I have an Access 2000 db with a memo field.
Into the memo field I put text with bold attributes, URL etc etc
What I need to to is converting the rich text contained into the memo
field in plain text.
That's because I truncate the string text but if, when I truncate it
there's a rich tag the code following the truncated string is corrupted.
Don't know if it's clear enough.
|
by: Shyguy |
last post by:
I want to create two buttons on a form. One would allow the user to
Copy the contents of the current records memo field, the other would
allow them to print. I set up a report based on the memo field, and
it works. But, it seems wrong since I had to create a huge text box to
accommodate memo fields with a lot of text.
Thanks for any help,
ShyGuy
|
by: Dalan |
last post by:
This seems a bit odd and probably I'm overlooking something, but have
not been able to change a text field to a memo one. Of course, I made
the change in the related Table setting, however the display in the
expanded box on the form stops at 255 characters regardless.
The box gets its data from a four column list box and is used for an
expanded report description. And yes, I tried changing the list box
to "memo" as well, but to no...
|
by: MLH |
last post by:
I have a form with two controls:
!! - combo box
!! - text box
A button on the form tries to run this SQL when clicked...
INSERT INTO BodyMsgsSent (ToWhom, BodyText)
SELECT DISTINCTROW !! AS MyTargets,
!! AS MyList;
When the SQL runs, it fails with msg saying "Field length is too
|
by: Adam |
last post by:
I am importing a table from Informix into Access XP via an ODBC
connection. In one of the fields, I will need it to allow 4000
characters. In Access help, it shows the data type can be changed to
"memo" and that will allow up to 65,535 characters. After importing
the table, I checked the data type and it automatically was set to
memo, but with the 255 character limitation. When I attempt to go
over 255, it will not allow it. Does...
| | |
by: Art |
last post by:
I've already posted a number of questions on this topic and everyone has been extremely helpful. I've yet another (related) question.
I want to bring a text file into an Access table using vb.net. With your help I've been able to do this. The problem I'm now running into is that the first row of the text file becomes my field names. Is there any way to specify the field names in the SQL -- when putting the data into a new table? Or... if...
|
by: Ennio-Sr |
last post by:
Hi all!
After a very long struggle I finally succeded in transferring my old
*.dbf file and the relating *.dbt (alias memo fields) to a pg table.
For the time being I put the memo field in a separate table having two
fields only (i.e.: n_memo integer, memo text) which can be related to
the main table in a view.
|
by: debert254 |
last post by:
I'm running a simple summary query. Prior to summarizing values in three columns I get the text values (i.e., "Medicare") for column 1. If I summarize I get "䄂˜" in place of the original text values.
Using Access 2003, SP2 under WinXP
The query:
SELECT Qtr_Report_In_County01.Memo, Qtr_Report_In_County01.Program, Qtr_Report_In_County01.Units
FROM Qtr_Report_In_County01
GROUP BY Qtr_Report_In_County01.Memo,...
|
by: lee1212 |
last post by:
Hi
I use vb.Net to open an access db for my software and i have one issue that i don't know how to do, I need to change an exsiting Column that might have some records in it from Text(250) to Memo type cuz i need to store some text that its length is more then 250.
Is there any way that i can do something like:
Alter Table TABLENAME {Alter Column COLUMN1 Memo}
and to change the column type from text to memo without delete the records?...
|
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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
