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...
Problem I have is that some of the strings in this field are up to 4000 characters :S
Fingers crossed there's something I can do without faffing around!
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...