I have this VBA code that is driving me nuts! It seems right to me, but the clipboard is always empty:
Me.[Case Attachments subform].SetFocus
DoCmd.GoToRecord , , acLast
Me![Case Attachments subform].Form![Doc Description].SetFocus
Me![Case Attachments subform].Form![Doc Description].SelStart = 0 ' Start of the text
Me![Case Attachments subform].Form![Doc Description].SelLength = Len(Me![Case Attachments subform].Form![Doc Description].Value) ' Entire length of the text
DoCmd.RunCommand acCmdCopy
I ran a checkpoint prior to the acCmdCopy and confirmed that the [Case Attachments subform].Form![Doc Description].Value is correct. How do i get the contents it has selected to the clipboard!!!