Case Question

  • Thread starter Thread starter alex
  • Start date Start date
A

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
 
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
 
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 -
Click to expand...

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