See Help on these functions:
To test for a field with no value:
If you are using functions that have optional arguments of type Variant that
may not be supplied, see:
To test for a Variant that is uninitialized, see:
To test if an object variable is not initialized:
If MyObject Is Nothing ThenReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13296
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.htmlReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13296
Reply to group, rather than allenbrowne at mvps dot org.
"Ray C" wrote in message
> In Basic, I was always able to test returned data to see if it was String
> If isstring(a) then
> if isnum(a) then etc
> but there does not seem to ne the same test available within Access VB. I
> sure that there must be and I am just not able to find it. Can anyone