Make textboxes visible or invisible 1

[Moss100]

Hello,

I am just learning how to code.

I have a form - repairs

I have a textbox text800
and
I have a textbox: text100

I would like code to make text100 not be visible when text800 is empty and be visble when text50 has soemthing in it.

I was thinking that the code should be addres to the on current event - is this correct?

I have tried:
If IsNull(Me.Text800) Then
Me.[text100].Visible = False
Else
If Not IsNull(Me.Text800) Then
Me.[text100].Visible = True
End If


Thanks for any help

 

[SkipVought]

Hi,

You are using a different syntax for text100 & text800...WHY???

Also the negation (the Else state) of IsNull() is ALREADY Not IsNull(). So why the second If, for which BTW, you have no End If!!!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Moss100]

Thanks for the reply - I wonder whether you could type the code that I should use - i've literally just begun learning code and you answer is probbely great, but a little advanced for me

Many thanks Mark

 

[Golom]

Something like

If IsNull(Me.Text800) Then
   Me.[text100].Visible = False
Else
   Me.[text100].Visible = True
End If

More concisely though

Me.[text100].Visible = NOT IsNull(Me.Text800)

 

[TheAceMan1]

How are ya Moss100 . . .

According to your logic, there are two unknown states:
[ol][li]txt800 IsEmpty and txt50 IsNotEmpty[/li]
[li]txt800 IsNotEmpty and txt50 IsEmpty[/li][/ol]
[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]