more than 3000 letters in a row

  • Thread starter Thread starter Ranjit kurian
  • Start date Start date
R

Ranjit kurian

Hi,

In my table one of the column contain more than 3000 letters/words, and all
are important msg, how can i put all the letters in one column...
 
From your description, it sounds like you already have "more than 3000
letters/words" in a column, but it sounds like you are asking how you can
put them in one column. I'm not understanding...

What is the data-type of the column you already have?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hi Jeff,

The problem iam facing is access accept only max 255 character in a column,
even though my Data-Type is memo , its not taking more than 255 character.
 
Hi Douglas,

Actually i did not understand what you have asked.

i just created a new table and in design mode i changed the data-type from
Text to Memo, thinking it can take more than 3000 character, but it did not
worked..

The main logic here is i want to create a table with columns that can fit
more than 3000 characters
 
And how did you determine that it "did not work"? What were the symptoms of
the failure and what were the steps you took that led to those symptoms?

You will get faster resolutions to your problems if you resolve to always
describe symptoms (error messages, etc) instead of using unhelpful terms
like "did not work".
 
Hi Bob,

Iam not getting any error , inspite it removes the character atuomatically
when it cross 255 characters.
 
OK, good description of the symptom. Now how about telling us the steps that
led to this symptom. How did you enter the data into this field? Manually
typing characters in a form or a datasheet? Using copy-paste from somewhere?
Using an update query? Using a recordset in VBA?
 
Hi Bob

The data is available in a Notepad, and this Notepad is linked to access
table, using Link_Tables option.
 
Hi Bob

The data is available in a Notepad, and this Notepad is linked to access
table, using Link_Tables option.
Click to expand...

Notepad is not a file type: it's a program. It would seem that your file is a
text file (does it have a .txt extension?); if so, it does not support a Memo
datatype. You will need to Import (not link) your file into an Access Table
containing a memo field and edit it there.
 
Back
Top