Vartype question

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.
 
A

Allen Browne

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
 
Top