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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vartype, range uninitialized ? Feb2010 2
Vartype() and vbObject 4
Calculated Field values question 1
Question about VarType 2
How to modify the Expression1 or 2 of an existing FormatCondition? 1
How to modify Expression1 or 2 in existing FormatCondition? 1
Error for return value of fld.type 4
Excel2000: Reading values from range, passed to function as parameter using an expression 3

Back
Top