Textbox won't display more than 255 characters on form

[jzacharias]

Couldn't find an answer to this problem. I am having trouble getting a textbox on a form to display more than 255 characters. The table field "Description" is set to memo and all the data is displayed in the table, but my textbox which has a control source set to =[OffenseSection].[Column](3) only displays the first 255 characters. My textboxes in my reports display all the characters. Is there possibly a limitation in the control source?

 

[MarkK]

You appear to be drawing the data for your Textbox, a display control, from the Column property of a Listbox or Combobox control, which are also display controls. Lists and Combos are mostly intended to be used as user interface selection tools, not text handling, so I suspect that is your bottle-neck.

Check out the DLookup() function and/or maybe you need to handle the click event of the list or combo and update directly update the textbox with data depending on what the user selected in the list?

Cheers,

 

[jzacharias]

Thank you... I will test your suggestion.

 

[MarkK]

You bet, happy new year.

 

[jzacharias]

DLookup worked like a charm...Thanks again