Access 2007 Form : Unbound text box : Memo field truncated

Question

I have a table with a memo field to hold descriptive notes. In a form I have a combo box whose data source query includes this memo field. After update of this combo box I set an unbound text box on the form to the appropriate column number from the combo box.

The memo field is truncated (probably to 255 chars). How can I get the whole memo field to display in the unbound text box?

It is the SQL that is truncating the field. I've tried setting it from a recordset collection but as that's also based on SQL the truncation also occurs.

This seems to be a relatively common problem but I've not been able to find a workaround anywhere.

Thanks in advance for any helpful suggestions...

This is a good start : allenbrowne.com/ser-63.html. If you can't find an answer there, show the query — Thomas G
Hi Thomas. Yes, I'd seen the AllenBrowne document although it doesn't help much. The combo box data source query is very straightforward - just columns selected from a single table :"SELECT ACReportType.ACRT_ID, ACReportType.ACRT_Description, ACReportType.ACRT_VBReportName, ACReportType.ACRT_Notes FROM ACReportType ORDER BY ACReportType.ACRT_Description; " — user7425513
I've also tried setting the form's RecordSource to the ACReportType table and adding the problematic memo field from the list from 'Add Existing Fields' but it still truncates. I've compared the field format etc. to its equivalent on the ACReportType maintenance form (where the memo field behaves 'properly') and I can't see any difference. — user7425513
This query is the comboboix record source, and then you are trying to move the memo data in the combobox to another textbox? right ? if yes, search no longer your data is truncated in the combobox and you can't change that. You will have to make an additional query to retrieve the whole memo field, after the user select something in the combobox — Thomas G

Gustav Gustav · Accepted Answer · 2018-05-05T15:41:32

One method is to use DLookup in the AfterUpdate event of the combobox:

Me!YourTextbox.Value = DLookup("[MemoField]", "YourTable", "ID =" & Me!YourCombobox.Value & "")

assuming the combobox is bound to field ID. Otherwise, use the column of the combobox that holds the ID to look up.

Access 2007 Form : Unbound text box : Memo field truncated

1 Answers