ACCESS FEED: RE: [MS_AccessPros] Re: What does the colon do in the ELSE: statement?

Jumat, 24 Juli 2015

RE: [MS_AccessPros] Re: What does the colon do in the ELSE: statement?

Bob - It's a non-nonsensical example made worse by being syntactically incorrect to start with.But my example is correct and will compile as it should.

While multiple statement lines are out of the ordinary, they are used from time to time. It's a matter of style. I tend to use them in If blocks if the Else line is short. Offhand, I can't think of any other place I'd use them.

Then there is the one-line If statement:

If suit = spades Then MsgBox "I win!"

No End If needed.

Another funny thing about VBA, you can type endif and the editor will fix it for you.

-Bill

---In MS_Access_Professionals@yahoogroups.com, <bob.phillips@dsl.pipex.com> wrote :

Surely, it should be

If 1 > 4 Then

MsgBox "1 is greater than 4"

Else

MsgBox "1 is less than 4"

End If

Or even

MsgBox "1 is " & IIf(1 > 4, "greater", "less") & " than 4"

Multiple statement lines just don't feel right to me.

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: 24 July 2015 16:24
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: What does the colon do in the ELSE: statement?

Phucon

As per Duane's explanation, the code should have been written:

If 1 > 4 Then

MsgBox "1 is greater than 4"

Else: MsgBox "1 is less than 4"

End If

Regards,

Bill Mosca, Founder - MS_Access_Professionals

http://www.thatlldoit.com

Microsoft Office Access MVP

https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

---In MS_Access_Professionals@yahoogroups.com, <duanehookom@hotmail.com> wrote :

I found this while searching the web http://stackoverflow.com/questions/7649101/excel-vba-pound-and-colon-signs-meaning

"The colon (:) is a statement delimiter. It would be equivalent to a new line in VBA, or a semicolon in C (just to quote a random example). It allows you to write several instructions on a single line rather than going to a new line each time."

Since your example code has not instruction on the same line after the ":" it serves no purpose.

Duane Hookom, MVP
MS Access

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 23 Jul 2015 08:21:06 -0700
Subject: [MS_AccessPros] What does the colon do in the ELSE: statement?

Hello

I am trying to understand the "ELSE:". Why is the colon necessary? What does it do there?

Thank you

Phucon

Sub IF_ELSEIF_FUNCTION()
If 1 > 4 Then
MsgBox "1 is greater than 4"
Else:
MsgBox "1 is less than 4"
End If
End Sub