Recent content by wakeboarder141

This has gotten me very close. I think I just need some help with formatting now. I have 2 text boxes overlapping each other, TPR3 and TPR Amt. TPR3 control source is =IIf([TPR Multplier]>"1",[TPR2],Null). TPR Amt is =IIf([TPR Multplier]<"1",[TPR Amount],Null). TPR2 refers to a hidden text...

The text does show through a little because of the alternating row color. The printing is good enough, but when users copy a row from the report view, the white text is also being copied.

This is a new one to me. Can you help me understand what this is doing? Do I use this as the control source? Thanks.

That explains why it isn't working. The problem with the conditional formatting route is that I need these these boxes to be each other and only have one of them visible at a time. Does conditional formatting support something other than changing colors that might work? When I try using the...

I have two text boxes on a report and would like to control which one is visible based on a value in another field. I can accomplish what I want in Print Preview by using VBA: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If [TPR_Multplier] > "1" Then...