Search results

Mr. vbaInet, I tried your solution and it works perfectly! Thank you very much for your help. I certainly appreciate it! :) Mr. B, Thank you for all the help that you have given me as well. I very much appreciate the time that you took to try out the code and verify for me that it was...

Mr. B, Thank you very much for trying this out and confirming the root cause of this issue. I certainly appreciate it! My guess is that this is a very serious bug in the 2007 release of MS Access. If you ever come across a work-around to this issue, I would greatly appreciate it if you...

Mr. B, Thank you for your fast response. I appreciate it. Unfortunately, I am not at liberty to post a copy of the database. I have VBA code in another portion of my database that is pretty much identical to the sample code that you provided and it works just fine in Access 2003 and...

Mr. B, Good question. I forgot to mention that piece of information. Yes, the copy operation is doing the truncating; not the paste operation. I set a breakpoint and examined the GloMtgText variable immediately after selecting the text and it only contains about 155 characters. It works...

I wrote VBA code that copies text that I have highlighted within a field (called "Description) in one form (Form A) and pastes it into a field by the same name but in a different form (Form B). When pasting it, it also adds a date stamp. The VBA code I wrote is as follows: 'Declare global...

I wrote VBA code that copies text that I have highlighted within a field (called "Description) in one form (Form A) and pastes it into a field by the same name but in a different form (Form B). When pasting it, it also adds a date stamp. The VBA code I wrote is as follows: 'Declare global...