Understanding the Select Case Statement

That's a poor example, because a city can have many, many Zipcodes. A much better example would be just the opposite! The user enters a Zipcode and the correct city would populate the textbox. This is good because it allows the demonstration of a number of ways presenting the case.

"Powhatan" shows a single value for the case expression.

"Petersburg" shows the use with a range of values for the case expression.

"Mechanicsville" shows the use when multiple, non-consecutive values are present.

"Richmond" shows the use with a combination of consecutive and non-consecutive values.

The final Case Else allows for the event that none of the Case expressions has been entered.


Linq ;0)>

Here's another little known way to use Select Case.

In this case, an average is being derived at and Ratings assigned accordingly. If the PointAverage is above a certain value, the Rating is thus and so.

If the PointAverage was, for the sake of this demo, 6.0, then the Case expression would satisfy every Case, because 6.0 is greater than 0, 1.5, 2.5, 3.5, 4.5 and 5.5! So which value is assigned to the control Rating?

In the Select Case construct, if a value satisfies more than one Case, the first Case that is satisfied is the one that is executed! To take advantage of this, you construct your Select Case in descending order, i.e. with the highest value first. So in this case, Rating would be assigned "U."

Likewise, with a PointAverage of 4.7, Rating would be assigned "E" because Case Is > 4.5 is the first Case that 4.7 satisfies.

Linq ;0)>

Thanks missinglinq this will help me out alot in my programming.

lee123

You can also use Select Case with string values and to do things other than assigning values to other controls. This example uses it to decide which reports to open:

Linq ;0)>

hey linq i tried a little experiment with the select case method and it didn't work. i put two textboxes (unbound) and named one name & the other one Lastname, but when i did the code. it didn't work i entered it like this:

maybe i did this wrong but inorder for me to get the full understanding i wanted to try it out. so i did and what do you know it didn't work.

Then i did this:

And this one worked. why is that. I also sub. the "FF" with a number (With No Quotes) and nothing. but the two letters worked. is this strange or did i miss something about this.

lee123

Firstly to respond to Linq's excellent and illustrative examples, but I will get back to your last question later Lee.

I recently found another way of using the Select Case construct for when the checks were not all comparing a single variable or state. It involves doing things logically 'A... about Face' if I can use that term. Otherwise think 'Backwards'.

Say you want to flag something to the operator if any of a number of conditions were true, then you could make something like :

Your code looks fine in both cases Lee, although I would take a closer look at the indenting used either in my example or in Linq's. Using Select Case can be very powerful, but wrong indenting can make it very complicated to read correctly.

We don't know how it failed or what data was entered (I'm thinking case particularly here) so I can be little further help at this time except to say that the code looked as if it should work. Look to the data entered.

Alternatively, try :

hi neopa thanks i'll try it and thanks for the other example

lee123

That's an interesting application of it, Ade!

lee123, go into your code window behind your form and go to the very top of it. I think you'll either not see any Option Compare statement, or you'll see the statement
Option Compare Binary. Absent an Option Compare statement, it defaults to Binary. This means that all comparison (like the Case statements) are case sensitive.

Change this statement or if missing simply enter Option Compare Database.
That should solve your problems.

Linq ;0)>

thanks linq I'll try it.

lee123

I've split another (hijack) question off into its own thread. Interested parties will find it here (Find Using Wildcard).