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

[nlyles]

I need to create a field that will contain Notes up to 2500 Characters. Is
this possible. Please help.

 

[Jeff Boyce]

Text fields in Access hold up to 255 characters. Memo fields hold up to
60,000+ characters.

Good luck

Jeff Boyce
<Access MVP>

 

[nlyles]

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?

 

[Jeff Boyce]

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>

 

[nlyles]

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