Gmail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
Yes/No
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  11 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
an  
View profile  
 More options Nov 5, 7:52 am
Newsgroups: microsoft.public.access
From: an <a...@discussions.microsoft.com>
Date: Wed, 4 Nov 2009 12:52:02 -0800
Local: Thurs, Nov 5 2009 7:52 am
Subject: Yes/No
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


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
John W. Vinson  
View profile  
 More options Nov 5, 10:16 am
Newsgroups: microsoft.public.access
From: John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com>
Date: Wed, 04 Nov 2009 16:16:27 -0700
Local: Thurs, Nov 5 2009 10:16 am
Subject: Re: Yes/No

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

             John W. Vinson [MVP]


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
KARL DEWEY  
View profile  
 More options Nov 5, 10:58 am
Newsgroups: microsoft.public.access
From: KARL DEWEY <KARLDE...@discussions.microsoft.com>
Date: Wed, 4 Nov 2009 15:58:20 -0800
Local: Thurs, Nov 5 2009 10:58 am
Subject: RE: Yes/No
>>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.


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
an  
View profile  
 More options Nov 5, 12:32 pm
Newsgroups: microsoft.public.access
From: an <a...@discussions.microsoft.com>
Date: Wed, 4 Nov 2009 17:32:01 -0800
Local: Thurs, Nov 5 2009 12:32 pm
Subject: RE: Yes/No
KD, thanks for reply

Sorry. I don't understand:
Val_Display

an


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Duane Hookom  
View profile  
 More options Nov 6, 2:19 am
Newsgroups: microsoft.public.access
From: Duane Hookom <duanehookom@NO_SPAMhotmail.com>
Date: Thu, 5 Nov 2009 07:19:02 -0800
Local: Fri, Nov 6 2009 2:19 am
Subject: RE: Yes/No
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


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
KARL DEWEY  
View profile  
 More options Nov 6, 9:28 am
Newsgroups: microsoft.public.access
From: KARL DEWEY <KARLDE...@discussions.microsoft.com>
Date: Thu, 5 Nov 2009 14:28:04 -0800
Local: Fri, Nov 6 2009 9:28 am
Subject: RE: Yes/No
Val_Display identifies a calculated field to control the display of [Val]
based on [Conf] selection.

--
Build a little, test a little.


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
an  
View profile  
 More options Nov 6, 11:31 pm
Newsgroups: microsoft.public.access
From: an <a...@discussions.microsoft.com>
Date: Fri, 6 Nov 2009 04:31:01 -0800
Local: Fri, Nov 6 2009 11:31 pm
Subject: RE: Yes/No
D H, Thank you for your explantion.
I try...

an


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
an  
View profile  
 More options Nov 6, 11:29 pm
Newsgroups: microsoft.public.access
From: an <a...@discussions.microsoft.com>
Date: Fri, 6 Nov 2009 04:29:01 -0800
Local: Fri, Nov 6 2009 11:29 pm
Subject: RE: Yes/No
K D, thanks for reply.

Return #NAME? at all.
an


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Rudolf Lamour  
View profile  
 More options Nov 7, 2:44 am
Newsgroups: microsoft.public.access
From: "Rudolf Lamour" <rudolflam...@freenet.de>
Date: Fri, 6 Nov 2009 16:44:06 +0100
Local: Sat, Nov 7 2009 2:44 am
Subject: Re: Yes/No

"KARL DEWEY" <KARLDE...@discussions.microsoft.com> schrieb im Newsbeitrag
news:8373E06E-53AA-4E36-A267-FD3322618D79@microsoft.com...


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
scott jr  
View profile  
 More options Nov 9, 7:29 am
Newsgroups: microsoft.public.access
From: "scott jr" <5caney>
Date: Sun, 8 Nov 2009 15:29:28 -0500
Local: Mon, Nov 9 2009 7:29 am
Subject: Re: Yes/No
hi scott jr let you know i like it thank you
scott jr
"Rudolf Lamour" <rudolflam...@freenet.de> wrote in message

news:%23Z6rEh9XKHA.3448@TK2MSFTNGP02.phx.gbl...


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
scott jr  
View profile  
 More options Nov 9, 7:27 am
Newsgroups: microsoft.public.access
From: "scott jr" <5caney>
Date: Sun, 8 Nov 2009 15:27:47 -0500
Local: Mon, Nov 9 2009 7:27 am
Subject: Re: Yes/No

"Rudolf Lamour" <rudolflam...@freenet.de> wrote in message

news:%23Z6rEh9XKHA.3448@TK2MSFTNGP02.phx.gbl...


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google