Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Is a blank column '' or null (2002)

    =IIf([Forms]![60300-frmJobCost-MainForm]![lstCustomers].[Column](2)="",[Forms]![60300-frmJobCost-MainForm]![CompanyNamex],[Forms]![60300-frmJobCost-MainForm]![ContactNamex])
    What am I doing wrong?
    Help!
    Frank Hoeffer

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Is a blank column '' or null (2002)

    And empty field, that is one that contains no data at all is null, not a zero length string (""). So the test you have to make is using the IsNull() function.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Is a blank column '' or null (2002)

    <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>
    Thanks that did it.
    Frank Hoeffer

Posting Permissions

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