Problem making things visible

[noe1818 via AccessMonster.com]

Here's my code:
If Me![Gender] = "Male" Then
Me.[B1].Visible = Me.[age] < 13
Me.[B3].Visible = Me.[age] 12

Else
Me.[B2].Visible = Me.[age] < 13
Me.[B4].Visible = Me.[age] 12
End If

I'm to get it so that if the person is (1st) male and (2nd) under 13 textbox
B1 is shown, and if the're >12 then B3 is shown. The else part is if the're
female with the same age groups.

The problem is that code works for "male", but when "female" is chosen, the
correct "female" box is shown along with both "male" boxes.
What do I need to change?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200804/1

[Wayne Gillespie]

On Tue, 01 Apr 2008 19:16:24 GMT, "noe1818 via AccessMonster.com" <u39419@uwe>
wrote:

>Here's my code:
If Me![Gender] = "Male" Then
Me.[B1].Visible = Me.[age] < 13
Me.[B3].Visible = Me.[age] 12

Else
Me.[B2].Visible = Me.[age] < 13
Me.[B4].Visible = Me.[age] 12
End If

I'm to get it so that if the person is (1st) male and (2nd) under 13 textbox
B1 is shown, and if the're >12 then B3 is shown. The else part is if the're
female with the same age groups.

The problem is that code works for "male", but when "female" is chosen, the
correct "female" box is shown along with both "male" boxes.
What do I need to change?

You need to handle all 4 textboxes in both arguments -

If Me![Gender] = "Male" Then
Me.[B1].Visible = Me.[age] < 13
Me.[B3].Visible = Me.[age] 12
Me.[B2].Visible = False
Me.[B4].Visible = False
Else
Me.[B2].Visible = Me.[age] < 13
Me.[B4].Visible = Me.[age] 12
Me.[B1].Visible = False
Me.[B3].Visible = False
End If
Wayne Gillespie
Gosford NSW Australia

[Patrick A]

I've also noticed that you may want to set each control's property to
Visible=n in the property sheet to make things appear (or not appear)
consistently.