Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 78
  • Last Modified:

code not working blocking NULL values

I am trying to handle NULLS in my code so I test for them first using this sequence

If Not rec.Fields(0) = Null Then
        Text1 = rec.Fields(0)
        End If

However, I notice that Text1 is not filling with data when the statement is true.  Is my syntax correct?
0
al4629740
Asked:
al4629740
1 Solution
 
käµfm³d 👽Commented:
If Not rec.Fields(0) Is Nothing Then

Open in new window

0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now