I'm having problems displaying MS Access fields over 255 chars. It keeps being truncated. How can I display the entire memo field? (Access 2000, IIS 5)
Or in the query analyzer built into Access?<BR><BR>If ASP, go see the ASPFAQs (link at top right of this page) and the various "Database" categories.<BR><BR>
Are you sure it's a memo field and not a text field? Is it an error with inserting or selecting? (open the database and see if it inserted more than 255 chars)
Yes, this is using ASP code. I'm looping through all the records returned from a qry with the memo field as the last field. The DB stores the strings over 255, but I'm only getting output of 255.
If may be putting our memo field text in an area which you can set a text limit on the HTML side like with <input type="text> or a textarea.