I'm trying to use this code but I get a diff error, namely 2465. But, instead of trying to use a field, I am trying to copy the contents of a string variable that I previously Dimentioned. My partial code is below:
So, is there a way to copy the string variable result onto the clipboard?
Dim Site as string
Site = rsNewData![Station] & ", " & rsNewData![SampleDate]
MsgAnswer = MsgBox(ScoreName & ", " & Site, vbOKCancel) ' for testing only
.SelStart = 0
.SelLength = Len(.Value)