Vartype question

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Hi All,

I am using vartype to debug 'empty' data fields and would like to display
the description instead of the value. What is the easiest way to do this in
a query please?

Ta.
Bill.
 
Bill, I'm not clear if you are saying you want TypeName() instead of
VarType()?

Only Variants can be Empty, so perhaps you are testing if the field is Null?

If you wanted to display the Description property of the Field in the
TableDef, see:
http://allenbrowne.com/func-06.html
 
Back
Top