View Single Post
  #1  
Old February 20th, 2007, 02:19 AM posted to microsoft.public.access.queries
ACCESS2007
external usenet poster
 
Posts: 6
Default Query output limiting field length - Access 2007

Below is Access SQL for review...
SELECT PublishingDetailsHistory.AgreementID,
PublishingDetailsHistory.SubjectMatter
FROM PublishingDetailsHistory
WHERE (((PublishingDetailsHistory.AgreementID)=1784));

The actual field length in the table for one of my records is 748 but the
query ouput is only showing 337. The next word in the string which is not
coming back is "layout,". Any advice on how to make the entire 748
characters show in query output?