Testing a field type

Results 1 to 2 of 2

Thread: Testing a field type

  1. #1
    Joannes De Koster Guest

    Default Testing a field type

    Hi,<BR>I&#039m trying to figure out a way to test the TYPE of field I&#039m reading in my ACCESS table : TEXT, MEMO, BOOLEAN...<BR>I&#039ve used the Vartype() function which works fine for a BOOLEAN TYPE, but this doesn&#039t see the difference between a TEXT and a MEMO field. Maybe someone knows an issue...<BR>dekoster@citeweb.net<BR>

  2. #2
    Stephen Fisher Guest

    Default RE: Testing a field type

    rs("yourfieldname").Type retirns the access datatype. You can then use the adovbs.inc file to determine what the numv=bers mwan.<BR><BR>Hope this helps<BR><BR>

Posting Permissions

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