 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / April 2005How can I create a text field in access tocontain 2500 characters
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 need to create a field that will contain Notes up to 2500 Characters. Is > this possible. Please help. 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 in Access hold up to 255 characters. Memo fields hold up to > 60,000+ characters. [quoted text clipped - 6 lines] > >I need to create a field that will contain Notes up to 2500 Characters. Is > > this possible. Please help. 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> >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 [quoted text clipped - 11 lines] >> >Is >> > this possible. Please help. > I don't have any idea how you can have more than 1,000 characters in a data > field typed as "text". 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 > > I don't have any idea how you can have more than 1,000 characters in > a data [quoted text clipped - 18 lines] > > -- |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.