Results 1 to 3 of 3
  1. #1
    jgelpi16 is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Location
    Charlotte, NC
    Posts
    544

    Question Null Check

    Here is my dilemma...

    I have the following code:


    Code:
    Dim varNullCheck
    Dim varRV
    varRV = RV.Value
    varNullCheck = Null
    If varRV = varNullCheck Then
        MsgBox "Must select RO.", vbOKOnly, "RO not selected"
        RV.SetFocus
        Exit Sub
    End If
    However, it is not working. Every time I run the code it skips right over the IF statement. Any suggestions will be greatly appreciated!!!!!

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    get rid of varnullcheck

    if isnull(varRV) Then
    ....
    end if

  3. #3
    jgelpi16 is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Location
    Charlotte, NC
    Posts
    544
    That is what I was looking for. Thank you!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. To check or Un-Check all Boxes in a form
    By devcon in forum Forms
    Replies: 7
    Last Post: 05-01-2010, 12:03 AM
  2. Replies: 6
    Last Post: 02-19-2010, 03:52 PM
  3. Replies: 5
    Last Post: 02-10-2010, 12:27 AM
  4. Is null problem
    By rockape in forum Programming
    Replies: 5
    Last Post: 09-29-2009, 12:46 PM
  5. A NULL Question
    By botts121 in forum Programming
    Replies: 2
    Last Post: 07-09-2009, 07:59 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums