Case Question

[alex]

Using the Case statement…

Is it possible to put a Case expression list on > 1 line?

E.g., this works:

Case "Denver", "Seattle", "Houston"

I’d like to do this instead:

Case
"Denver",
"Seattle",
"Houston"

I’ve tried all the VBA text wrapping tricks that I can think of!

Any thoughts?

alex

 

[Tom van Stiphout]

On Tue, 21 Jul 2009 06:16:32 -0700 (PDT), alex <[email protected]>
wrote:

VBA requires line continuation characters when spanning _any_
statement over multiple lines, so you could write:
Case _
"Denver", _
"Seattle", _
"Houston" _

-Tom.
Microsoft Access MVP

 

[alex]

VBA requires line continuation characters when spanning _any_
statement over multiple lines, so you could write:
Case _
"Denver", _
"Seattle", _
"Houston" _

-Tom.
Microsoft Access MVP










- Show quoted text -

Thanks Tom, that worked...I thought I tried that. I guess not!
alex