VBA not recognizing Null value

Question

Working in MSAccess. I'm trying to toggle the visibility of a button based on the value of a text box. The form was created off of a query. I've made sure the value in the tbl_Manufacturer.Website is Null. But the code keeps validating as false and drops into the next set of code. What did I miss?

Private Sub Form_Load()

    If ([Forms]![frm_Asset]![tbl_Manufacturer.WebSite]) = Null Then
            
        btn_Hyperlink.Visible = False
    
    Else
        
        btn_Hyperlink.Caption = [Forms]![frm_Asset]![tbl_Manufacturer.WebSite]
        btn_Hyperlink.Visible = True
    
    End If

End Sub

-Jeff

Erik A · Accepted Answer · 2020-08-12 18:38:28Z

3

Nothing is ever equal to Null, since Null is a missing value. Something = Null is always going to return Null, which evaluates to false.

If you want to test if a field is null, use the IsNull function:

If IsNull([Forms]![frm_Asset]![tbl_Manufacturer.WebSite]) Then

answered Aug 12, 2020 at 18:38

Erik A

32.8k13 gold badges48 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

JMJ Over a year ago

ISNULL! Thank you Erik, completely forgot that!

Mr Rob · Accepted Answer · 2020-08-12 18:40:43Z

0

Try using IsNull instead:

If (IsNull([Forms]![frm_Asset]![tbl_Manufactuer.Website]) Then ......

Testing if a string is null

answered Aug 12, 2020 at 18:40

Mr Rob

791 silver badge7 bronze badges

Comments

Psychoceramics · Accepted Answer · 2020-08-12 22:58:10Z

-1

In addition to the IsNull option presented by other answers, you can simply compare to an empty string, since this is a text box:

If ([Forms]![frm_Asset]![tbl_Manufacturer.WebSite]) Is Not "" Then

answered Aug 12, 2020 at 22:58

Psychoceramics

457 bronze badges

Collectives™ on Stack Overflow

VBA not recognizing Null value

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related