Return Respective Type

[squirrelly1]

Hello Ladies and Gents,

I created small class to make my data access easier on this project (why else should we have classes if not to make our lives a little more sane and keep our hair longer???).

The only snag I have run into is the following:

I would like for the code snippet below to be changed so that it returns the data in whatever datatype it was formatted in within my Access DB...

I'm sure this has been done before and that one of you will probably deside to doze of as you answer it, but it's been buggin' me just the same.

Public Function GetVal(ByVal Field As String) As String
        If IsNothing(RS) Then Exit Function
 
        Try
            Return Convert.ToString(RS.Fields(Field).Value)
        Catch ex As Exception
            Return ""
        End Try
    End Function

Thanks in advance,

Squirrelly1