Forum Discussion
Solved
Bring to Front and Turn Visible On - Report
Hello Experts, I have been trying to get this one field on my report to turn visible on and bring to front if another field is Null or "". The below is what I have and it doesnt seem to do anyt...
Format events only work in Print Preview
Can't see anything obvious that's wrong....Are both controls on the detail section?
Try the opposite logic. Make txtAcctNoFront visible by default then use this code
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Nz(Me.txtAcctNo, "") <> "" Then Me.txtAcctNoFront.Visible = False End Sub
Hi, thanks for the response. I am still having an issue unfortunately. The hidden field txtAcctNoFront doesnt appear. I have it placed in the front and not behind any other fields.
The property of the field named txtAcctNo is TEXT since there are letters sometimes.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Nz(Me.txtAcctNo, "") = "" Then Me.txtAcctNoFront.Visible = True
End Sub
I have the following in the field txtAcctNoFront (it performs as expected):
=IIf(Nz([txtAcctNo],"")="","**Chk IBAN**",Null)
Let me know if I am doing something wrong. thank you.
I tried both Print Preview and Report View thinking there is possibly a difference.
The property of the field named txtAcctNo is TEXT since there are letters sometimes.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Nz(Me.txtAcctNo, "") = "" Then Me.txtAcctNoFront.Visible = True
End Sub
I have the following in the field txtAcctNoFront (it performs as expected):
=IIf(Nz([txtAcctNo],"")="","**Chk IBAN**",Null)
Let me know if I am doing something wrong. thank you.
I tried both Print Preview and Report View thinking there is possibly a difference.
Format events only work in Print Preview
Can't see anything obvious that's wrong....
Are both controls on the detail section?
Try the opposite logic. Make txtAcctNoFront visible by default then use this code
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Nz(Me.txtAcctNo, "") <> "" Then Me.txtAcctNoFront.Visible = False
End Sub