Background:[/u]
I have a list box whose record source is a query based on a linked SQL Server 2000 table. The query and list box have 3 fields: (1) an ID field (2) A UserName field, and (3) a Notes field; only column 2 is visible to the user. Next to the list box is an unbound, locked text box. When the user selects a UserName in the list box, code executes loading the Notes in the locked text box ( a look, but don’t touch approach). The code is:
Me.txtSpecifiedNote = Me.lstAllNotes.Column(2)
The datatype of the Notes field in the underlying SQL table is nvarchar with a length of 500, though the linked table believes the datatype to be memo; I suppose that’s as close as Access can get.
Here’s the problem:[/u]
If a user chooses a note than contains 500 characters, only 255 characters are displayed in the text box. As far as I can tell, there is no limit associated with the text box control. If I open the list box’s query, the full note of 500 characters is displayed. The finger seems to be pointed at the .Column property of the list box. Is a list box capped at 255 characters? (which, not incidentally I’m guessing, is the max. characters in the Access datatype of Text) 
