check textbox1 on each record of report

[sconard]

I cannot seem to find the combination of event and method to check the value of a textbox for each record in an Access report.
For example using TextboxA, TextboxB:(both on main report)
if TextboxA does not have a value, than show textboxB
I have tried going to the report in design mode, clicking on the detail header, selecting the "on format" event and going to the code editor and entering



If Nz(textBoxName, "") & "" <> "" Then
textBox2Name.Visible = True
Else
textBox2Name.Visible = False
End If

but if I place a breakpoint at the conditional, the code is never reached

[pbaldy]

Make sure you open the report in Preview mode. The format events do not fire in Report view.

[sconard]

So where do I put this code if I want it to also appear in report view?
If I place similar code in the expression for the data for the control, the results only show for the first page. I am not certain if that is because the report has a subreport or not.

[pbaldy]

I'm not sure you can use code for report view. I'd probably use Conditional Formatting; you can't set visible, but you can change the font color to match the back color, effectively making the textbox invisible. Or you can use an expression:

=IIf(Nz(textBoxName, "") & "" <> "", FieldName, "")

[sconard]

As mentioned: The use of this expression only functions for the first two records or is limited to seemingly the first page

[pbaldy]

Just tested this in the detail section of a report in report view:

=IIf(Nz([MechanicName],"")<>"",[ServiceDate],"")

and it worked exactly as expected.

[sconard]

And the expression works exactly as expected for me as well on the first page of the report. Unfortunately the subsequent pages do not function. I think it has something to do with there being a sub report present but I cannot find the answer.

[pbaldy]

Can you post the db, or a representative sample?

[sconard]

After nearly giving up on this I demonstrated the issue on another machine. On that machine the same database actually shows all records as expected. What is odd is that the field that is generated by the expression does not show up on subsequent records on the dev box but appear on a client machine with the same version of Access (2007). Further: The expression field flickers when the report is scrolled on the client machine. It sometimes disappears and within as much as 7 seconds, reappears.