Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    7

    Question 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?

    Thanks!

  2. #2
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    See the help file for the VarType() function.

    Sam

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •