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