Checkbox ticked, textbox value is shown

[mflower]

I've got a check box (chkboxPrint)and a text box (txtboxNote). What I want to do is show the text box value if the check box is ticked.

What's wrong with:

If chkboxPrint.Value = 1 then txtboxNote.Show = True?

Thanks

 

[braindead2]

because checkbox value when checked = -1

 

[JoeMiller]

In the AfterUpdate event of your check box put this code:

txtboxNote.Visible = chkboxPrint

HTH Joe Miller
joe.miller@flotech.net

 

[mflower]

thanks for the code. i tried writing the code in the report but does not work, anyone knows how to use the same logic in the report. txtboxNote.visible = chkboxPrint if the chkbox is ticked in the report as well?

 

[JoeMiller]

Use an iif statement to examine the the box by placing this the control source of a text box on the report:

=IIf([Forms]![MyFormName]![chkboxPrint]=-1,[Note],"&quot

What that statement does is look at chkboxPrint on [MyFormName] and see if it's yes (-1). If it's yes then it shows the field named [Note], otherwise it shows nothing.
Joe Miller
joe.miller@flotech.net