Invisble when empty problem

[Sue Compelling]

Hi

I'm trying to make a text box and labels invisible when another field is
empty.

I've tried the following code on Form_Current though an error message comes
back with "Invalid use of Null"

Help ...

Me.OrgType.Visible = Me.OrgTitle = ""

TIA

 

[AccessVandal via AccessMonster.com]

Maybe try something else like

Me.OrgType.Visible = Len(Me.OrgTitle)

 

[Sue Compelling]

Hi

Unfortuately this too comes back with Invalide use of Null ...

 

[Dirk Goldgar]

Hi

I'm trying to make a text box and labels invisible when another field is
empty.

I've tried the following code on Form_Current though an error message
comes
back with "Invalid use of Null"

Help ...

Me.OrgType.Visible = Me.OrgTitle = ""

If OrgTitle is "empty", it's likely that its value is Null, not the
zero-length string "". Try this:

Me.OrgType.Visible = Not IsNull(Me.OrgTitle)

That will hide OrgType when OrgTitle is Null. If you wanted to *show*
OrgType when OrgTitle is Null, you would take out the "Not":

Me.OrgType.Visible = IsNull(Me.OrgTitle)

 

[Sue Compelling]

Thanks so much Dirk - it works!!!

 

[AccessVandal via AccessMonster.com]

Sorry, forgot about that. It should be this to avoid the nulls

Me.OrgType.Visible = Len(Me.OrgTitle & "")