<div>
What is your SQL statement? &nbsp;Or at least the expression you are using for the fields that are getting truncated?<br />
<br />
Take a look at this article for common reasons that Memo fields get truncated and some solutions. &nbsp;The same reasons and solutions apply when linking to a SQL Server back-end:<br />
<br />
<a href="http://allenbrowne.com/ser-63.html" rel="ugc">http://allenbrowne.com/ser-63.html</a>
</div>


What is your SQL statement?  Or at least the expression you are using for the fields that are getting truncated?

Take a look at this article for common reasons that Memo fields get truncated and some solutions.  The same reasons and solutions apply when linking to a SQL Server back-end:

http://allenbrowne.com/ser-63.html [http://allenbrowne.com/ser-63.html]

<div>
How do I know if it's a memo field?
</div>


<div>
<div class="content wysiwyg-content">
I'm running a query that returns multiple columns from multiple tables.<br />
The query executes perfectly, but there seems to be a restriction on the amount of characters returned.<br />
<br />
How can I increase this restriction in Access?
</div>
</div>


I'm running a query that returns multiple columns from multiple tables.
The query executes perfectly, but there seems to be a restriction on the amount of characters returned.

How can I increase this restriction in Access?

Access Query on SQL ODBC Connected DB character limit on fields

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.