title: How to create a comment box with time and date stamp in Access using VBA
body: <p>Completely new to VBA and need help with detailed instructions (dummy version for me).</p>
  
  <p>I have a table with various columns and the following columns, specifically:</p>
  
  <p>ReviewerComments
  NewComment</p>
  
  <p>I created a form with both of these fields and need to create an Append Comment button that moves the text from NewComment field and appends it to ReviewerComment field and time/date stamps the comments as they are added.  I named this button cmdAppendComment.</p>
  
  <p>I had seen someone else post something and I tried, but as I am completely new to this I know I messed it up.  Any help is greatly appreciated.</p>
  
  <p>This is what the VBA code looks like right now:</p>
  
  <pre><code>Private Sub cmdAppendComment_Click()
  If (IsNull(NewComment.Value)) Then
      MsgBox ("Please provide a comment before clicking" &amp; _
          "on the Append Comment button.")
      Exit Sub
    End If
  
    If (IsNull(ReviewerComments.Value)) Then
      ReviewerComments.Value = NewComment.Value &amp; " ~ " &amp; _
             VBA.DateTime.Date &amp; " ~ " &amp; VBA.DateTime.Time
    Else
      ReviewerComments.Value = ReviewerComments.Value &amp; _
             vbNewLine &amp; vbNewLine &amp; _
             NewComment.Value &amp; " ~ " &amp; _
             VBA.DateTime.Date &amp; " ~ " &amp; VBA.DateTime.Time
    End If
  
    NewComment.Value = ""
  
  End Sub
  </code></pre>