Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBNull Date (2k)

    when i put VbNull as my false statement related to a date field, when the value is null i get a date entered of 12/31/1889 or something like that. Shouldn't it be nothing? I changed it to make the value = "", but I don't understand why a null field returns an actual date... <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: VBNull Date (2k)

    Please provide some context. This is incomprehensible to me, sorry.

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,265
    Thanks
    2
    Thanked 187 Times in 173 Posts

    Re: VBNull Date (2k)

    vbNull as a constant actually has a value of 1. Try using Null instead.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •