title: Convert values from Access Combo Box to string
body: <p>I need to convert the values from combo box to a string so I can add that string to a variable, to a function to eventually add to a database. 
  Here is my sub that grabs text from my form and from the combo box: </p>
  
  <pre><code>Private Sub cbRowStudentGrade_Change()
  
  
    Course_ID.SetFocus
    rowCourseID = Course_ID.Text
  
    StuRed_ID.SetFocus
    rowStudentRedID = StuRed_ID.Text
  
    cbRowStudentGrade.SetFocus
    cbRowStudentGrade = cbRowStudentGrade.Column(0)
  
    CurrentDb.Execute "qryInputGrades"
  
  
    MsgBox (rowCourseID)
    MsgBox (rowStudentRedID)
    MsgBox (cbRowStudentGrade)
  
  
    Requery
    Repaint
  End Sub
  </code></pre>
  
  <p>And here are the functions that I am using as criteria in my Access query builder. </p>
  
  <pre><code>Public Function funcRowCourseID() As String
  
    funcRowCourseID = rowCourseID
  
  End Function
  
  
  Public Function funcRowStudentRedID() As String
  
    funcRowStudentRedID = rowStudentRedID
  
  End Function
  
  
  Public Function funcCbRowStudentGrade() As String
  
    funcCbRowStudentGrade = cbRowStudentGrade
  
  End Function
  </code></pre>
  
  <p>My query:</p>
  
  <pre><code>INSERT INTO tblRegistrationGrade ( Red_ID, Course_ID, Grade )
  VALUES (funcRowStudentRedID(), funcRowCourseID(), funcCbRowStudentGrade());
  </code></pre>
  
  <p>I think there is a datatype mismatch between the database and what the combobox value actually is. But, if there were a datatype mismatch wouldn't there be an error stating as such? My database requires <code>short text</code>, which these are. </p>