Query is truncating data?!

[MkIIISupra]

I have a simple query set up to pull data from a memo field in one table and append it to a memo field in another table based on a pre-defined set of criteria. The query is used to populate a field on a form, from there when a user selects an item it will then populate the memo field on the form. One of my test cases I have a string of text within the source memo field that is 756 chars long. But when I run the query it truncates to 255! This is really stumping the heck outta me! Below is the SELECT SQL that I have from the query:

SELECT tblFaqList.question, tblFaqList.subject, tblFaqList.response, tblFaqList.grade, tblFaqList.questionNum
FROM tblFaqList INNER JOIN tblTmpCallType ON tblFaqList.subject = tblTmpCallType.subject
WHERE (((tblFaqList.subject)=[tblTmpCallType]![subject]) AND ((tblFaqList.grade)=[tblTmpCallType]![grade]) AND((tblFaqList.questionNum)=[tblTmpCallType]![questionNum]));

Here is the VBA code used in conjunction with the query above.

Me.callDesc.Value = Me.shortDesc.Column(2) 'And Me.grade.Value = Me.shortDesc.Column(3)
Me.callDesc.SetFocus
intLen = Len(Me.callDesc)

Me.callDesc is also a memo field.

When I run just the query without the form the field tblFaqList.response is truncated, so I have determined that it's not the form causing the issue. It is definitely the query. But I am stumped as to how to correct this!!!

Here are the two tables involved, in hopes this will help.

tblFaqList – Holds commonly asked questions and is used to fill in other fields based on specific search criterion.
grade = Text (3)
questionNum = Text (3)
question = Memo
subject = Text (35)
response = Memo
addDate = Date/Time
addTime = Date/Time

tblMainLog – Main call storage table
callIdNum = AutoNumber
callIdNumDupe = Number
regionId = Text (2)
regionName = Text(50)
callDate = Date/Time
callTime = Date/Time
csrInit = Text(3)
custFname = Text(28)
custLname = Text(35)
custPhnNum = Text(10)
custPhnExt = Text(5)
custAltPhn = Text(10)
custEmail = Text(125)
callType = Text(35)
grade = Text(3)
itemNum = Text(3)
shortDesc = Memo – This is fed on the form by qrySELECT_Subject which the SQL above is for.
callDesc = Memo

There are more fields but this is good enough to illustrate the set-up. So any idea as to why this thing is truncating?

As always Thank you very much in advance!

One by one the penguins steal my sanity!

 

[dhookom]

A column of a list or combo box will never contain more than 255 characters. If that is what you require, you will need to find another solution.

You stated "here are the tables involved" but you don't list anything for "tblTmpCallType" which is in your query.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]