How to store string longer than 65K characters in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table where in one of it's field i dump email that i received from
my contact persons. For that field i used Memo datatype since i though it
will be enough. However, sometime i need to dump emails that are longer than
65K which is more than the limit of Memo field.
What other data type can i used to store text which has more than 65K
characters?
 
It is _not_ necessarrily 64K. Here is what Access Help says about Memo
Field:

"Up to 65,535 characters. (If the Memo field is manipulated through DAO and
only text and numbers [not binary data] will be stored in it, then the size
of the Memo field is limited by the size of the database.)"

If you manipulate the text in code, i.e. not through the Access GUI, Memo
Field can store more than 64K. I think the 64K is the limit of the TextBox.
 
Thanks for your reply.
However since i did my work through GUI (cut and paste), i assume i only
have 2 choices to overcome this situation. First, by opening the table
directly and paste my data. Second, as you pointed out, by using code.

Is it possible to read clipboard data and then paste the data into Memo
field using code?

regards,

Trias H

Van T. Dinh said:
It is _not_ necessarrily 64K. Here is what Access Help says about Memo
Field:

"Up to 65,535 characters. (If the Memo field is manipulated through DAO and
only text and numbers [not binary data] will be stored in it, then the size
of the Memo field is limited by the size of the database.)"

If you manipulate the text in code, i.e. not through the Access GUI, Memo
Field can store more than 64K. I think the 64K is the limit of the TextBox.

--
HTH
Van T. Dinh
MVP (Access)




Trias said:
I have a table where in one of it's field i dump email that i received from
my contact persons. For that field i used Memo datatype since i though it
will be enough. However, sometime i need to dump emails that are longer than
65K which is more than the limit of Memo field.
What other data type can i used to store text which has more than 65K
characters?
Click to expand...
Click to expand...
 
Thanks.

Since i use GUI to do the process (cut and paste data from Outlook), is it
possible to read clipboard data, paste it into Memo field using code which is
run from Access form?.

regards,

Trias H

Van T. Dinh said:
It is _not_ necessarrily 64K. Here is what Access Help says about Memo
Field:

"Up to 65,535 characters. (If the Memo field is manipulated through DAO and
only text and numbers [not binary data] will be stored in it, then the size
of the Memo field is limited by the size of the database.)"

If you manipulate the text in code, i.e. not through the Access GUI, Memo
Field can store more than 64K. I think the 64K is the limit of the TextBox.

--
HTH
Van T. Dinh
MVP (Access)




Trias said:
I have a table where in one of it's field i dump email that i received from
my contact persons. For that field i used Memo datatype since i though it
will be enough. However, sometime i need to dump emails that are longer than
65K which is more than the limit of Memo field.
What other data type can i used to store text which has more than 65K
characters?
Click to expand...
Click to expand...
 
Back
Top