Convert return constant value from integer to text, ex: dbtext=10

[GSMike]

Does anyone know how to convert a returned field property from the numeric value to the text property?
Example:

msgbox fld.type

returns
10

How do you get it to return
dbText?

Thanks for your help.
Mike Kemp

 

[GSMike]

Oops!! Answered my own question.
I just created a "select case" function that went through all 21 data types and converted the integer values to string values that way.
Thanks anyway!
Voting myself tipmaster of the week, by the way.