Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Testing Returned Data

Discussion in 'Information Technology' started by Ray C, Jul 28, 2006.

  1. Ray C

    Ray C
    Expand Collapse
    Guest

    In Basic, I was always able to test returned data to see if it was String or
    Numeric:-
    If isstring(a) then
    if isnum(a) then etc
    but there does not seem to ne the same test available within Access VB. I am
    sure that there must be and I am just not able to find it. Can anyone help?

    Thanks
     
  2. Loading...


  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    See Help on these functions:
    VarType()
    TypeName()
    IsNumeric()
    IsDate()

    To test for a field with no value:
    IsNull()

    If you are using functions that have optional arguments of type Variant that
    may not be supplied, see:
    IsMissing()

    To test for a Variant that is uninitialized, see:
    IsEmpty()

    To test if an object variable is not initialized:
    If MyObject Is Nothing Then

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Ray C" <RayC@discussions.microsoft.com> wrote in message
    news:EB6F1836-DD25-430B-A021-CC2BEA85F529@microsoft.com...
    > In Basic, I was always able to test returned data to see if it was String
    > or
    > Numeric:-
    > If isstring(a) then
    > if isnum(a) then etc
    > but there does not seem to ne the same test available within Access VB. I
    > am
    > sure that there must be and I am just not able to find it. Can anyone
    > help?
    >
    > Thanks
     
  4. Ray C

    Ray C
    Expand Collapse
    Guest

    Thanks for this Alan. I tried "isnum() and isnumber() isstring() etc, etc
    but, of course these would not work. I could not find them in the Help files
    because I did not know the name to request help on.

    Thanks once again aAan

    Ray C

    "Allen Browne" wrote:

    > See Help on these functions:
    > VarType()
    > TypeName()
    > IsNumeric()
    > IsDate()
    >
    > To test for a field with no value:
    > IsNull()
    >
    > If you are using functions that have optional arguments of type Variant that
    > may not be supplied, see:
    > IsMissing()
    >
    > To test for a Variant that is uninitialized, see:
    > IsEmpty()
    >
    > To test if an object variable is not initialized:
    > If MyObject Is Nothing Then
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > "Ray C" <RayC@discussions.microsoft.com> wrote in message
    > news:EB6F1836-DD25-430B-A021-CC2BEA85F529@microsoft.com...
    > > In Basic, I was always able to test returned data to see if it was String
    > > or
    > > Numeric:-
    > > If isstring(a) then
    > > if isnum(a) then etc
    > > but there does not seem to ne the same test available within Access VB. I
    > > am
    > > sure that there must be and I am just not able to find it. Can anyone
    > > help?
    > >
    > > Thanks

    >
    >
    >
     

Share This Page