Is there a function that will tell me what field type a memory variable is? I have an activeX control getting information from a spreadsheet and the field type is either character or numeric. I need to know what type it is.

Here is the line that captures the data

Tmp = oXL.ActiveSheet.Cells(TmpSVRow,1).VALUE

I am doing an IF statement and I need it to be a character field. Here is the if statement beginning. I have few lines that are numeric.

IF ALLTRIM(Tmp) = "Runoff Balance Book"

Thanks for your help
Todd