Memo Form Field Length

  • Thread starter Thread starter Arthur H. MacLeod
  • Start date Start date
A

Arthur H. MacLeod

I have a form that references a table Memo field. This table Memo field
holds more than 255 characters. The form will only display 255 characters.
Queries and reports show all the characters related to this field. Why does
the form field limit the number of characters displayed?
 
I have a form that references a table Memo field. This table Memo field
holds more than 255 characters. The form will only display 255 characters.
Queries and reports show all the characters related to this field. Why does
the form field limit the number of characters displayed?
Click to expand...

I would guess that you are using a Query which groups by or sorts on
the memo field. Remove the sorting/grouping and see if that solves the
problem.
 
Post the SQL String (of the Query) you used as the RecordSource for the
Form.

Since JET cannot sort / order Memo Fields, if you have grouping or sorting
in the Query, JET trucates the Memo Field values to 255 characters before
sorting / grouping.
 
I think this is what you requested. The offending memo field is
ProjectData.WorkDescription.

I have a Project Summary Query that pulls together data from a ProjectData
Table, an Owner SubTable, a Client Table, and a Profile Table. All my other
querys rely on this query.

The Project Summary Query is as follows:

SELECT ProjectData.ProjectName, ProjectData.StatusYear,
ProjectData.ConstructionCost, ProjectData.Fee, ProjectData.JobRole,
ProjectData.Phases, ProjectData.ListTown, ProjectData.ListState,
ProjectData.ListResidential, ProjectData.ListFederal,
ProjectData.ListPrestige, ProjectData.ListHistoric, ProjectData.JobNumber,
ProjectData.WorkDescription, ProjectData.ProjectDescription,
ProjectData.JobCaptain, ProjectData.StatusCycle, ProjectData.PublicPrivate,
ProjectData.ProfileCodeSubTable, Profile.Code, ProjectData.ProjectCity,
ProjectData.ProjectState, ProjectData.ClientFirm, ProjectData.OwnerSubTable,
Owner.OwnerName, Client.ClientReference, Client.ReferencePhone,
Client.Profession
FROM Profile RIGHT JOIN ((Owner RIGHT JOIN ProjectData ON
Owner.OwnerName=ProjectData.OwnerSubTable) INNER JOIN Client ON
ProjectData.ClientFirm=Client.ClientFirm) ON
Profile.Profile=ProjectData.ProfileCodeSubTable;


Arthur

======================================================
 
Back
Top