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

 

Phucon

Okay, I understand. this is how I check for Null or ""

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

Me.lblTotal.Visible = Len(Me.txtTotal & vbNullString)<>0

End Sub

Regards,

Bill Mosca

---

From: saigonf7q5@yahoo.com
To: "MS Access Professionals" <MS_Access_Professionals@yahoogroups.com>
Sent: Friday, February 28, 2014 3:09:46 PM
Subject: [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 (4)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___