Yes/No

  • Thread starter Thread starter an
  • Start date Start date
A

an

Hi!

I have a continous form with checkbox Yes/No named Conf and textbox named Val.
When I click in Conf the check boxes are all Visibles

I have:

Private Sub Conf_Click()
If Me.Conf = True Then
Me.Val.Visible = True
Else
Me.Val.Visible = False
End If
End Sub

When I click one checkbox all Val textboxes turn to visible.
I would like to turn textbox visiible only when respective Conf is True.

Thanks in advance.
an
 
Hi!

I have a continous form with checkbox Yes/No named Conf and textbox named Val.
When I click in Conf the check boxes are all Visibles

I have:

Private Sub Conf_Click()
If Me.Conf = True Then
Me.Val.Visible = True
Else
Me.Val.Visible = False
End If
End Sub

When I click one checkbox all Val textboxes turn to visible.
I would like to turn textbox visiible only when respective Conf is True.

Thanks in advance.
an
Click to expand...

Data is not stored in forms. It's stored in Tables. An unbound checkbox on a
form will just have one value - even if it's displayed repeatedly.

You may want to use Format... Conditional Formatting to change the proeprties
of the Val field based on the (stored in a table!!!) Conf value.
 
When I click one checkbox all Val textboxes turn to visible.
I am pretty sure they are all the same object.

You might use an IIF statement in the query like this --
Val_Display: IIF([Conf] = True, [Val], "")
 
KD, thanks for reply

Sorry. I don't understand:
Val_Display

an


KARL DEWEY said:
I am pretty sure they are all the same object.

You might use an IIF statement in the query like this --
Val_Display: IIF([Conf] = True, [Val], "")

--
Build a little, test a little.


an said:
Hi!

I have a continous form with checkbox Yes/No named Conf and textbox named Val.
When I click in Conf the check boxes are all Visibles

I have:

Private Sub Conf_Click()
If Me.Conf = True Then
Me.Val.Visible = True
Else
Me.Val.Visible = False
End If
End Sub

When I click one checkbox all Val textboxes turn to visible.
I would like to turn textbox visiible only when respective Conf is True.

Thanks in advance.
an
Click to expand...
Click to expand...
 
You can't control a single instance of a control in a continuous form like
this. You might be able to use Conditional Formatting which can set the
properties of a single control on a continous form.

--
Duane Hookom
Microsoft Access MVP


an said:
KD, thanks for reply

Sorry. I don't understand:
Val_Display

an


KARL DEWEY said:
When I click one checkbox all Val textboxes turn to visible.
Click to expand...
I am pretty sure they are all the same object.

You might use an IIF statement in the query like this --
Val_Display: IIF([Conf] = True, [Val], "")

--
Build a little, test a little.


an said:
Hi!

I have a continous form with checkbox Yes/No named Conf and textbox named Val.
When I click in Conf the check boxes are all Visibles

I have:

Private Sub Conf_Click()
If Me.Conf = True Then
Me.Val.Visible = True
Else
Me.Val.Visible = False
End If
End Sub

When I click one checkbox all Val textboxes turn to visible.
I would like to turn textbox visiible only when respective Conf is True.

Thanks in advance.
an
Click to expand...
Click to expand...
Click to expand...
 
Val_Display identifies a calculated field to control the display of [Val]
based on [Conf] selection.

--
Build a little, test a little.


an said:
KD, thanks for reply

Sorry. I don't understand:
Val_Display

an


KARL DEWEY said:
When I click one checkbox all Val textboxes turn to visible.
Click to expand...
I am pretty sure they are all the same object.

You might use an IIF statement in the query like this --
Val_Display: IIF([Conf] = True, [Val], "")

--
Build a little, test a little.


an said:
Hi!

I have a continous form with checkbox Yes/No named Conf and textbox named Val.
When I click in Conf the check boxes are all Visibles

I have:

Private Sub Conf_Click()
If Me.Conf = True Then
Me.Val.Visible = True
Else
Me.Val.Visible = False
End If
End Sub

When I click one checkbox all Val textboxes turn to visible.
I would like to turn textbox visiible only when respective Conf is True.

Thanks in advance.
an
Click to expand...
Click to expand...
Click to expand...
 
K D, thanks for reply.

Return #NAME? at all.
an

KARL DEWEY said:
Val_Display identifies a calculated field to control the display of [Val]
based on [Conf] selection.

--
Build a little, test a little.


an said:
KD, thanks for reply

Sorry. I don't understand:
Val_Display

an


KARL DEWEY said:
When I click one checkbox all Val textboxes turn to visible.
I am pretty sure they are all the same object.

You might use an IIF statement in the query like this --
Val_Display: IIF([Conf] = True, [Val], "")

--
Build a little, test a little.


:

Hi!

I have a continous form with checkbox Yes/No named Conf and textbox named Val.
When I click in Conf the check boxes are all Visibles

I have:

Private Sub Conf_Click()
If Me.Conf = True Then
Me.Val.Visible = True
Else
Me.Val.Visible = False
End If
End Sub

When I click one checkbox all Val textboxes turn to visible.
I would like to turn textbox visiible only when respective Conf is True.

Thanks in advance.
an
Click to expand...
Click to expand...
Click to expand...
 
D H, Thank you for your explantion.
I try...

an

Duane Hookom said:
You can't control a single instance of a control in a continuous form like
this. You might be able to use Conditional Formatting which can set the
properties of a single control on a continous form.

--
Duane Hookom
Microsoft Access MVP


an said:
KD, thanks for reply

Sorry. I don't understand:
Val_Display

an


KARL DEWEY said:
When I click one checkbox all Val textboxes turn to visible.
I am pretty sure they are all the same object.

You might use an IIF statement in the query like this --
Val_Display: IIF([Conf] = True, [Val], "")

--
Build a little, test a little.


:

Hi!

I have a continous form with checkbox Yes/No named Conf and textbox named Val.
When I click in Conf the check boxes are all Visibles

I have:

Private Sub Conf_Click()
If Me.Conf = True Then
Me.Val.Visible = True
Else
Me.Val.Visible = False
End If
End Sub

When I click one checkbox all Val textboxes turn to visible.
I would like to turn textbox visiible only when respective Conf is True.

Thanks in advance.
an
Click to expand...
Click to expand...
Click to expand...
 
KARL DEWEY said:
Val_Display identifies a calculated field to control the display of [Val]
based on [Conf] selection.

--
Build a little, test a little.


an said:
KD, thanks for reply

Sorry. I don't understand:
Val_Display

an


KARL DEWEY said:
When I click one checkbox all Val textboxes turn to visible.
I am pretty sure they are all the same object.

You might use an IIF statement in the query like this --
Val_Display: IIF([Conf] = True, [Val], "")

--
Build a little, test a little.


:

Hi!

I have a continous form with checkbox Yes/No named Conf and textbox
named Val.
When I click in Conf the check boxes are all Visibles

I have:

Private Sub Conf_Click()
If Me.Conf = True Then
Me.Val.Visible = True
Else
Me.Val.Visible = False
End If
End Sub

When I click one checkbox all Val textboxes turn to visible.
I would like to turn textbox visiible only when respective Conf is
True.

Thanks in advance.
an
Click to expand...
Click to expand...
Click to expand...
 
Rudolf Lamour said:
KARL DEWEY said:
Val_Display identifies a calculated field to control the display of [Val]
based on [Conf] selection.

--
Build a little, test a little.


an said:
KD, thanks for reply

Sorry. I don't understand:
Val_Display

an


:

When I click one checkbox all Val textboxes turn to visible.
I am pretty sure they are all the same object.

You might use an IIF statement in the query like this --
Val_Display: IIF([Conf] = True, [Val], "")

--
Build a little, test a little.


:

Hi!

I have a continous form with checkbox Yes/No named Conf and textbox
named Val.
When I click in Conf the check boxes are all Visibles

I have:

Private Sub Conf_Click()
If Me.Conf = True Then
Me.Val.Visible = True
Else
Me.Val.Visible = False
End If
End Sub

When I click one checkbox all Val textboxes turn to visible.
I would like to turn textbox visiible only when respective Conf is
True.

Thanks in advance.
an
Click to expand...
Click to expand...
Click to expand...
 
hi scott jr let you know i like it thank you
scott jr
Rudolf Lamour said:
KARL DEWEY said:
Val_Display identifies a calculated field to control the display of [Val]
based on [Conf] selection.

--
Build a little, test a little.


an said:
KD, thanks for reply

Sorry. I don't understand:
Val_Display

an


:

When I click one checkbox all Val textboxes turn to visible.
I am pretty sure they are all the same object.

You might use an IIF statement in the query like this --
Val_Display: IIF([Conf] = True, [Val], "")

--
Build a little, test a little.


:

Hi!

I have a continous form with checkbox Yes/No named Conf and textbox
named Val.
When I click in Conf the check boxes are all Visibles

I have:

Private Sub Conf_Click()
If Me.Conf = True Then
Me.Val.Visible = True
Else
Me.Val.Visible = False
End If
End Sub

When I click one checkbox all Val textboxes turn to visible.
I would like to turn textbox visiible only when respective Conf is
True.

Thanks in advance.
an
Click to expand...
Click to expand...
Click to expand...
 
Back
Top