title: Clearing textbox upon click
body: <p>I'm relatively new to VBA, and am working on a small database for my employer. I'm trying to create a text box that, when clicked, deletes the contents that I have put in it. For example, I have a text box that says "first" for them to put in the first name of a member. When they click it, I want my text to disappear so they can enter what they want. (The matter of it only executing once is easily solved with an if statement). I've taken a look at the following question, but neither answer worked for me;</p>
  
  <p><a href="https://stackoverflow.com/questions/4068576/clear-text-in-textbox-upon-clicking-it">Clear text in textbox upon clicking it</a></p>
  
  <p>The following code did nothing</p>
  
  <pre><code>Private Sub TextBox1_GotFocus()
  TextBox1.Text = ""
  End Sub
  </code></pre>
  
  <p>And the following code give me an "Expected, end of statement" compilation error on 'Handles';</p>
  
  <pre><code>Private Sub txtNewNameHere_GotFocus() Handles txtNewNameHere.GotFocus
  txtNewNameHere.Text = ""
  End Sub
  </code></pre>
  
  <p>Not sure why either of those did not work for me, but, as I said, I'm relatively new to this. Any help greatly appreciated.</p>