Pass through query - Varchar(MAX) to TextBox

[Mad_Philly]

Hi all,

I have an MS Access 2007 front end displaying data provided by parameterised pass through queries to SQL. Although the data comes across without any problem it's not presented as I'd like it in the form. I'm referring particularly to a text box which contains a brief description of the results of an examination. The 'Report' field in the SQL table is a Varchar (Max) due to the number of characters and when the query is executed manually the entire amount of text is displayed, but when executed as through VBA the textbox limits the display to 255 characters.

Any thoughts...??

Any help is appreciated I'm banging my head against the wall here.

Andy

 

[Mad_Philly]

Okay, I've found a solution for this in case anyone else suffers it.

To describe my situation:

I have several listboxes populated by Pass Through Queries which are dynamically changed using QueryDef in VBA when a user clicks Search. I was then populating a Report based on selections made from the resulting Listboxes by assigning the value to the report textboxes at Report_Load.

Now I have created another Pass Through Query specifically for populating the textbox that I'm having trouble with and assigning the value to it using a Dlookup. Now the text is entered in full and the textbox is not limited to 255 characters!!


Wooohoo!!