Search results for query: *

We have a winner! Thank you TonyJollans! That solution worked like a charm. thank you for saving me from another day of banging my head against a wall. As an aside when does the control source re-execute the function? Strongm, I believe you are right in that replace is not limited to 2048...

Hmm... No luck, it has the same complaint as the regular textbox. My working theory is to try dumping the info using the SendKeys function. Access says that a textbox can hold up to 65535 characters, and I have users entering these long answers into the database through a textbox, so I know...

Back for more. The ultimate goal for this string is to appear in a form. I have the string going into a textbox, and I was setting the .controlSource field to the value of the string. But this property doesn't like strings longer than 2048. I experimented with the .value and .text...

Wow guys, I had no idea that VBA had Regular Expressions in it. When you search the help, there's no mention of it at all. Also, thanks for introducing me to the entire world of references, which I didn't know existed. I wonder how much incredibly useful stuff is in there but is overlooked...

I'll have to loop through the string cause it could go greater than 4096, but yes the left function is exactly what I was looking for. thanks for the prompt reply!

Hi folks, Is there a clean way to run the equivalent of the 'replace' function on a string of greater than 2048 characters? I'm thinking of parsing the string into chunks of less than 2048 characters and running replace on each substring, but I can't find a function that will parse a string...