[MS_AccessPros] RE: How do I display a label caption only when the text box has a value (not null).

 

Hello Bill

I tried it, however it doesn't changed. I put a breakpoint at the group footer's Format event, why does it never break. It only happened (break) 1 time, and I forget how I triggered it.

Private Sub GroupFooter3_Format(Cancel As Integer, FormatCount As Integer)

Me.lblTotal.Visible = Not IsNull(Me.txtTotal)

End Sub

I found this if statement sytax "If Me.txtTotal & "" = "" Then" in an VBA book (Programmer's Referene), it is for Checking for Nulls, and it says it's this technique uses the concatenation behavior of the & operator and is the same as " If IsNull(Me.txtTotal) or Me.txtTotal = "" Then"

Phucon

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (3)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___