Printing Problem

Originally Posted by Stewart Ross Inverness

Hi. Your code is ok, as long as the control called Paid on your report is indeed a boolean (true/false) value, and when it runs it should hide or show the controls in the detail section of your report accordingly. When you say that the report does not print the information, can you advise whether or not the controls concerned are always being shown, always being hidden, or what?

-Stewart

Originally Posted by Wayneyh

The checkbox called Paid is a (true/false) value. If it is checked on the Form PaymentConfirmation then it shows the information on the report. This works fine as i can see it on the screen until i want to print the report off. All the information on the report prints fine apart from the information from the code below which doesn't come out on the print out. the information is being pulled from a query. Do i have to put this code into the query or the form before it reaches the report for it to work?

Originally Posted by Stewart Ross Inverness

Hi. The code is fine - you don't have to place this anywhere other than where it is for it to do its job. However, you say in your reply that Paid is on your form. It is not the form which matters - the field Paid must be included in the query on which your report is based, and it must also be included as a control in the detail section of your report. You can set the properties for the control to Visible=No to hide it if you wish not to see it, but it must be present on your report. If it is not there the DetailFormat code will not be able to refer to it and test its value.

I am wondering if you are actually referring to two different things here - I would guess the use of a single check box on the form which is to be ticked to show all values paid and unticked to show all values not paid, with the need to show or hide particular controls on your report. If, as I suspect, this is the case there are other ways to do it. Please let me know in your next response.

-Stewart

Originally Posted by Wayneyh

Yes that is correct. Please advise

Originally Posted by Stewart Ross Inverness

OK. I am taking it that you are confirming that there is a single check box on your form which filters the form to show paid or unpaid records, and you want to implement this for your report.

You need to provide more information about what is in the query on which your report is based. In particular, I need to know the names of the main fields of this query which are of interest in showing and hiding payment details. I would also appreciate a copy of the After Update code for the checkbox in your form, as this will tell me how the form is being filtered to show only the paid or unpaid records.

-Stewart

Originally Posted by Wayneyh

I have managed to fix the problem. Thanks for your help anyway.