Unanswered: Determine Data Types for a Field in a Table?
Hi, is there a way to determine a data type for fields in a table programmatically within a function?
Basically, the database has a function that allows the end user to multi-select fields within the subform and create queries on the fly. Unfortunately the fields are both numeric and text therefore, the code will only work for one data type and not the other.
A work around is that an IF statement is inserted within the function because really only 2 fields are text fields, however, was wondering if there's an easier way to do this?