Originally Posted by CJ_London
Yes/No,True/False and -1/0 are all the same thing which is numeric so I would just use the getnumeric function
Fixed it for good this time (I think :O).
Public Function getNumericText(ByVal field_name As String) As String
getNumericText = Me(field_name)
Public Function getStringText(ByVal field_name As String) As String
getStringText = "'" & Replace(Me(field_name), "'", "''") & "'"
Public Function getDateText(ByVal field_name As String) As String
getDateText = "#" & Format(Me(field_name), "mm/dd/yyyy") & "#"
I'm running all True/False fields through the getNumericText function.