Search results

I have, in fact, checked with the Debug.Print function to make sure the string is holding more than 255 characters, and it is. In the meantime I've figured out how to write the string to a text file and then run a macro in Word from Access to read that text file and write it to the Word text...

This is the code that I've been using (with some variations in the names): docWord.FormFields("bmkVerification6a").Result = strVerification where "bmkVerification6a" is the bookmark attached to the text field in the Word document, "docWord" is the Document object, and "strVerification" is the...

No, the string has been parsed together from 2 or more smaller strings, each of which originate from text-type fields.

Hi everyone, I'm reposting this to see if I can get some additional help as I've been unsuccessful at resolving this problem. I've created a form-based application using Access that helps users automatically fill out a Word form. For the most part, everything is working great EXCEPT when I...

Right now I can only assume that the limit is 255 characters. This was established through trial. Basically, I tried parsing strings together right up that limit, and so far anything larger hasn't passed. How would you go about doing what you've suggested with printing to a text file and so...

Unfortunately, that didn't work. Same result as before.

Thanks, tranchemontaigne. I tried both your suggestions, and I think I know what the problem is, but I still don't know how to fix it. It doesn't appear to be either a special character problem, OR a code size problem, but rather a string size problem. After I threw the code into a new...

I'm trying to use Access 2003 VBA to automatically fill in a Word form with text fields; however, in several instances, I'm having difficulty passing a parsed string to a field. The following code is an example of what I've been using. strVerification = "" If...