Query field got truncated

[perryc]

All, I have the following text in a table, it displays fine. (Long field, plain text format). However, when pull to Query, it got truncated. Why?



Workday and HOMECARE INSTITUTE (HCI) courses to include Home Health and Hospice Virtual Orientation – Recorded. Click “Bon Secours Mercy Health” on the left side of the page, Locate the following by course number: 1. Home health Care Services course 1070005 (1 hr.), 2. Home Care Basics Course 1070008(1 hr.) 3. Home Care Beyond the Basics course 1070019 (1 hr.) 4. Wound Care Basics course 1130001 (1 hr.)

It only displays up to 107000 right before the 2.

I have searched for solutions, but it seems nothing works. Including this: http://allenbrowne.com/ser-63.html


Please share some insight. Ty

Sincerely,
Perry

[pbaldy]

What's the SQL of the query and name of this field?

[perryc]

I did more investigation, actually the query itself is ok, but it may have to do with the text field in the Form and in the report. They got truncated.

[perryc]

Paul, ty so much for jumping in. I did more investigation, actually the query itself is ok, but it may have to do with the text field in the Form and in the report. They got truncated. The field is just called CourseDetails

[ranman256]

Msoft didn't bother fixing that bug. Long texts will truncate at 255 in a query. Thanks Microsoft.

[pbaldy]

Can you attach the db here, or at least the objects needed to duplicate this issue?

[perryc]

I do not know how. I am so sorry. I am at work, so, my work blocked all Google and Onedrive as well. Ahhhh.. Well, basically I created a field in a form and made that a multi-select box querying from a table with these text, text seems appear ok in Query, just not in the form or report

Workday and HOMECARE INSTITUTE (HCI) courses to include Home Health and Hospice Virtual Orientation – Recorded. Click “Bon Secours Mercy Health” on the left side of the page, Locate the following by course number: 1. Home health Care Services course 1070005 (1 hr.), 2. Home Care Basics Course 1070008(1 hr.) 3. Home Care Beyond the Basics course 1070019 (1 hr.) 4. Wound Care Basics course 1130001 (1 hr.)



I did more test, if I create a form, and pull in the Table, it displays all the characters. However, what I did was a drop down box instead to bring in the field, and it is truncated. I am confused.

[pbaldy]

Ah, the problem is the combo box. It appears a textbox will display everything, a combo won't. Why are you using a combo? I found this with a possible solution:

https://social.msdn.microsoft.com/Fo...nto-a-combobox

[perryc]

Ty so much!!! I will read the link. Well, the reason for the Combo box is because I want to allow people to choose from a drop down list. Ty again.