Printpreview problem 1

[Tom123456]

Hello all!
I have a form with a checkbox and a printpreview button. How can I in the printpreview (when I have pressed the button) the value of the checkbox and the diside if a textfield should be shown or not.



- Tom

 

[KenReay]

Hi

In the relavant section of the form, OnFormat event

If Forms!MyForm!MyCheckBox = True Then
MyTextBox.Visible = True
Else
MyTextBox.Visible = False
End If

Using your own form and control names of course

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[KenReay]

Hi

OOPS Sorry!

should have said

In the relavant section of the REPORT, OnFormat event



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Tom123456]

That worked just great!!, Thanks a lot!!. I got the answer to this question in less than 1 minute!!



- Tom

 

[Tom123456]

Hello again!

(Follow up question.)

The report read values from a table with 222 records. When I remove the textboxes I only want to show one page. How do I do?

- Tom

 

[KenReay]

Hi

You mean you want to print only one record?

See the DoCmd.OpenReport syntax in help, you can set the unique identifier of the record within the docmd

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Tom123456]

Thanks again, Ken!!

I found it and the solution was like you said:
DoCmd.OpenReport "REPORT_NAME", acViewPreview, "", "WHERE CONDITION"

- Tom