title: Copy text using VBA in Access 2007
body: <p>I try to copy the <code>strContents</code> into clipboard but I can't.
  My code is: </p>
  
  <pre><code>Dim value_currency As Variant
  Dim strContents As String
  
  value_currency = value_currency_txt.value
  strContents = NumberToString(value_currency) &amp; " (" &amp; Format(value_currency_txt.Value, "Currency") &amp; ")"
  
  DoCmd.RunCommand acCmdCopy
  </code></pre>
  
  <p><code>NumberToString</code> converts number to string.</p>
  
  <p>When I use <code>MsgBox strContents</code> gives me the desired result but when I try to copy the <code>strContents</code> it gives me an error 2406 - the command copy isn't available now.</p>
  
  <p>How can I copy the text into clipboard?</p>