Results 1 to 3 of 3
  1. #1
    George is offline Competent Performer
    Windows 7 64bit Access 2013 64bit
    Join Date
    Feb 2012
    Posts
    295

    Reference a control of string datatype

    Good night.



    I am referencing a control of datatype string. But the reference is ignored. this is my statement. Can anyone explain what is missing?


    HTML Code:
    If Forms![order Details]![payment Type] = Null Then
     
      MsgBox "Yes"
      
      
     End If

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Cannot test for Null like that. Review http://allenbrowne.com/casu-12.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    George is offline Competent Performer
    Windows 7 64bit Access 2013 64bit
    Join Date
    Feb 2012
    Posts
    295
    Thank. understood. working fine.

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

Similar Threads

  1. Single string reference for multiple fields
    By PinkLady50 in forum Programming
    Replies: 5
    Last Post: 05-16-2017, 11:38 AM
  2. Replies: 2
    Last Post: 07-13-2016, 08:28 AM
  3. Replies: 15
    Last Post: 05-12-2016, 02:27 PM
  4. Replies: 1
    Last Post: 10-06-2015, 06:50 AM
  5. Make subform control reference with a string
    By dcdimon in forum Programming
    Replies: 2
    Last Post: 04-01-2014, 02:24 PM

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