Yes/No

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
 
J

John W. Vinson

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.
 
K

KARL DEWEY

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], "")
 
A

an

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...
 
D

Duane Hookom

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...
 
K

KARL DEWEY

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...
 
A

an

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...
 
A

an

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...
 
R

Rudolf Lamour

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...
 
S

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...
 
S

scott jr

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Text to End of Footnote 9
Requery subform doesn't display all records 1
Show Label & Text Box in Report based on Checkbox 3
Help with My Macros Program 1
Programming my macro 0
Help with hiding column(s) 4
Locking a record via a form 2
What event occurs After form record is loaded 2

Top