Moving Memo in Subform to Textbox on Main Form Truncated 1

[NorwalkPhil]

My subform displays a list of various types of problems. When the user clicks on a particular problem, the suggested fix is displayed in a textbox on the main form.

Everything works fine except that the data is truncated to 255 characters.

Main form = ODS2Dashboard
Textbox on ODS2Dashboard = tbSuggestedFix
Subform = mySubform
Memo field in the query that mySubform is bound to = [SuggestedFix]

Code from On Current event of mySubform:
Private Sub Form_Current()
Forms!ODS2Dashboard!tbSuggestedFix.Value = [SuggestedFix]
End Sub

I need to prevent the data from being truncated.

Sure seems easy enough...

I'd greatly appreciate any suggestions!

 

[lameid]

Access is not using the text box as a memo datatype...

The only thing I can think of is to bind the mainform. When I do this I add a yes/no field to the temporary type table and make it the Primary Key and the default value yes. That way you do not end up with a bunch of records on accident.

 

[MajP]

I am not sure if I understand Lameid's response, but a textbox does not limit the amount of characters. Any unbound textbox will hold up to I think 65k characters. If that textbox is bound to a text field it can only hold 255. So the truncation is in either in the original query (and many queries will truncate your memo fields) or the textbox is bound to a text datatype field. The text box should be bound to a memo field or unbound.

 

[lameid]

MajP,

I don't think you misunderstood me... I think I just straight up remembered that wrong. But everything you wrote is familiar.

 

[MajP]

These are the usual culprits:

http://allenbrowne.com/ser-63.html