Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,412
    I think OP is saying that button should be disabled if either field is null.
    Code:
    If Len(Me!Company_Name & vbnullstring) = 0 OR Len(Me!Country & vbnullstring) = 0 Then
          btnAdd.Enabled = False
    Else
          btnAdd.Enabled = True
    End If


  2. #17
    margzj is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Location
    Dubai
    Posts
    41
    Quote Originally Posted by davegri View Post
    I think OP is saying that button should be disabled if either field is null.
    Code:
    If Len(Me!Company_Name & vbnullstring) = 0 OR Len(Me!Country & vbnullstring) = 0 Then
          btnAdd.Enabled = False
    Else
          btnAdd.Enabled = True
    End If
    thank you this works. sorry im not good in english i cannot explain well

  3. #18
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,412
    English was good enough - we got the job done!

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 06-30-2017, 10:56 AM
  2. Check if unbound textbox is null
    By matt_wpg in forum Programming
    Replies: 8
    Last Post: 06-21-2017, 08:23 PM
  3. Replies: 4
    Last Post: 01-14-2014, 01:28 PM
  4. How to Check If Two Fields are Null?
    By alpinegroove in forum Programming
    Replies: 5
    Last Post: 01-04-2012, 01:41 PM
  5. Null Check
    By jgelpi16 in forum Programming
    Replies: 2
    Last Post: 06-04-2010, 12: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