How can I create a text field in access tocontain 2500 characters

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

Guest

I need to create a field that will contain Notes up to 2500 Characters. Is
this possible. Please help.
 
Text fields in Access hold up to 255 characters. Memo fields hold up to
60,000+ characters.

Good luck

Jeff Boyce
<Access MVP>
 
I should have been more clear. In my table I have changed this to a text
field. I am only getting a 1,111 character return. What am I doing wrong?
 
Text fields (text data type) cannot hold more than 255 characters in Access.
I don't have any idea how you can have more than 1,000 characters in a data
field typed as "text".

Jeff Boyce
<Access MVP>
 
Jeff said:
I don't have any idea how you can have more than 1,000 characters in a data
field typed as "text".
Click to expand...

I do. Using Jet 4.0 DLL e.g.

CREATE TABLE Test (data_col TEXT(50));

results in a column of type TEXT. However:

CREATE TABLE Test (data_col TEXT);

results in a column of type MEMO.

BTW the '60,000' is AFAIK a limit of the MS Access UI but i guess you
had this covered by saying '60,000+ characters' <g>. I'm left wondering
if the quoted limit of '1,111' could actually be 1024, which might
suggest another limitation e.g. a particular Form control, maybe?

Jamie.

--
 
Okay, I at first had the field as text. Then I changed it to memo and tested
a note that actually had 1234 characters by putting in on a form that had
been created. When checking the count the charachter count that they table
held was actually 1,111. I used the LEN function
 
Back
Top