Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Feb 2006
    Posts
    71
    Thanks
    1
    Thanked 0 Times in 0 Posts

    real field content (2003)

    Using VBA, I'm reading a cost field in an imported Excel sheet. Sometimes the field is "blank" and the code crashes with "invalid use of Null". The field content does not appear to be either NULL or "" . I have tried to skip the read with: IF 'is null' or "" then stop statements but it does not stop. I cannot tell what the "blank" field contains.

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

    Re: real field content (2003)

    Does it help if you use the Nz function, as in Nz([FieldName], 0)

Posting Permissions

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