Notes Truncating from dBaseIV table

F

Fred Block

Hi All,

I've got a couple of dBaseIV tables linked into Access. When I view the
Notes field I see all of the data. However, when I use the Notes field in a
SELECT query, I'm only getting the first 255 characters of the note. Is
there somewhere I can change the amount of data the query will return for
this Notes field? I'm using this query to generate a report and that is how
I noticed this was happening.

TIA - Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text in note pane of "normal" display suddenly much larger 1
Append Crosstab Query to Existing Table 0
Group by truncating field 1
Make Table Query Truncating Memo Field at 255 Characters 1
Insert Index into a Table 1
SQL Strings Truncating at 255 Characters ? Why? 1
Use data from DBaseIV table in Excel 2007? 0
Word doc keeps changing to ALL CAPS 0

Top