Re: isnumeric compile error...

Addiing to your point,

?isnumeric(abcde)
True

in the immediate window.

But on a form in a textbox it yields False.
Of course, in the form's textbox, abcde
is being viewed as data. And in debug,
well, it's not readily apparent ...

?abcde

?VarType(abcde)
0 (empty, unitialized)

.... which is not the same as vbVariant (12).
So, I don't think there's enough substance
here to base an argument on in either direction.
I don't think what's happening is something
that was carefully planned or intended - or
even addressed for that matter. I think it's a
screw-up & the ADT overlooked it altogether.
.

Relevant Pages

  • Re: isnumeric compile error...
    ... But on a form in a textbox it yields False. ... Of course, in the form's textbox, abcde ... When you can show me that garbage in doesn't result in garbage out you will convince me, and millions of programmers world wide, that a miracle has taken place. ...
    (comp.databases.ms-access)
  • Re: AfterUpdate Event not Running
    ... immediate window, as you suggested. ... Jim ... > txtVenName isn't an object until the userform is loaded. ... >> I went into a Userform and selected a textbox ...
    (microsoft.public.excel.programming)
  • Re: vb newbie help
    ... To move the insertion point to the end of the textbox (and thus scroll ... to the Immediate Window. ...
    (comp.lang.basic.visual.misc)
  • RE: test for ...expression that has no value
    ... > I've tested the values in the immediate window and it's clear that the error ... I have a function which is called from a textbox on a form. ... The function takes the value of a field form my query ... but that didnt trap the error either. ...
    (microsoft.public.access.forms)
  • inability to change unbount textbox default value programmatically
    ... I'd like to be able to make the current value of a textbox on a form ... Debug.Print "orig", Me.tbxYear.DefaultValue ... default value change shows up in the immediate window, ...
    (microsoft.public.access.formscoding)