Paul,
Thank you for your help, I have tried what you suggested, and I placed it
behind a button and a msgbox for testing,
msodsc.CurrentSection.DataPage.Recordset.Fields("ReturnedtoDev").Value
returns True or False
So the If statement gets evaluated but
ReturnedtoDev.visible = false
doesn't hide the checkbox, also when I use the ALT-RightArrow to help me
with the syntax visible is not one the listed attributes for the Control.
What do you suggest?
Regards,
Michael Arch.
"PaulD" wrote:
> The datapagecomplete event is where you want your code. From there it
gets
> tricky since I don't know how your page is setup. Something like this
> should get you going in the right direction
>
> <SCRIPT language=vbscript event=DataPageComplete(oEventInfo) for=MSODSC>
> <!--
> dim ShowText
> ShowText =
>
msodsc.CurrentSection.DataPage.Recordset.Fields("your_checkbox_fieldname").Value
> If ShowText = "Yes" then 'not sure of this, it may be true -1 or some
other
> value you will need to verify
> textbox1.visible = false
> textbox2.visible = false
> End If
> -->
> </SCRIPT>
>
> This assumes the default value for the boxes is visible.
>
> "Michael" <Michael@[EMAIL PROTECTED]
> wrote in message
> news:F6E269C9-F57C-4D3B-9C47-BA31BD293F71@[EMAIL PROTECTED]
> :I have a simple Data Access Page that runs from a simple query. I need
to
> : find a way to hide a few controls (Text Boxes).
> : The control that will decide the faith of the textboxes is a Checkbox,
the
> : field in the source table for this checkbox is a Yes/No field, I want
the
> : text boxes to be hidden when the Check box is not checked as well as
the
> : check box otherwise everything should be visible.
> :
> : --
> : Regards,
> :
> : Michael Arch.
> :
> :
>
>
>
|
