Hi Paul,
Sorry I was away for so long, I was working on another project and also started school recently.
When I run the code above I get a "subscript out of range" error for the same line of code as before:
Code:
StrTxt = Format(Trim(Split(.Text, "-")(0)), "MMMM D, YYYY")
I'm at a loss, I've been working on it all day. Even my older version of this monster is now giving the error and before it worked fine. Any ideas?
-Donna
Is it possible that changing a reference in Access would affect MS Word?? I added a ref to Microsoft ActiveX Data Objects 2.5 Library for a module. Could that be the problem?