RE: [AccessDevelopers] If & Visible statement

Tue, 20 Dec 2005 11:33:15 -0800

So you think use the Enable/disable and just set that up in the VB language?

Eric Douglas <[EMAIL PROTECTED]> wrote:
As Tom said, you can't do this on continuous forms.  Instead, you might
consider the use of conditional formatting.  You can set certain
controls to be enabled/disabled based on other values in the record.

I am pretty certain conditional formatting can make a control visible or
not visible, however.  The best you can do is enable/disable controls.

Eric

> -----Original Message-----
> From: AccessDevelopers@yahoogroups.com
> [mailto:[EMAIL PROTECTED] On Behalf Of Joe
> Sent: Tuesday, December 20, 2005 7:51 AM
> To: AccessDevelopers@yahoogroups.com
> Subject: [AccessDevelopers] If & Visible statement
>
> I have a few statements that I am useing to make an item
> visible if somehting is populated.  But I think I'm doing
> something wrong.  If the field is populated for one item all
> the forms are affected.  I am using a continious view on my
> form.  How would I set it so it is only making the field
> viewable for that one record. 
>
> I have a main form with Tabs and then each tab has a subform
> on it too.
>
>
>
> Private Sub Declined_AfterUpdate()
> If IsNull(Me.Declined) Then Me.DeclinedNotes.Visible = False Else
> Me.DeclinedNotes.Visible = True
> End Sub
>
> Private Sub LeadGenerator_AfterUpdate()
> If IsNull(Me.LeadGenerator.Value) Then Me.LeadGenerator_Other.Visible
> = False Else Me.LeadGenerator_Other.Visible = True
> End Sub
>
> Private Sub NotAwarded_AfterUpdate()
> If IsNull(Me.NotAwarded) Then Me.NotAwardedNotes.Visible = False Else
> Me.NotAwardedNotes.Visible = True
> End Sub
>
>
>
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> Most low income homes are not online. Make a difference this
> holiday season!
> http://us.click.yahoo.com/5UeCyC/BWHMAA/TtwFAA/q7folB/TM
> --------------------------------------------------------------
> ------~->
>
>
> Please zip all files prior to uploading to Files section.
> Yahoo! Groups Links
>
>
>
> 
>
>
>

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com


Please zip all files prior to uploading to Files section.



SPONSORED LINKS
Microsoft access developer Microsoft access help Microsoft access database
Microsoft access training Microsoft access training course Microsoft access programming

YAHOO! GROUPS LINKS



Reply via email to