Tom Gonser, I beleive the variable to be used in the case statement is to only be declared in the first line of the Select Case. Also the optional directive "IS" is to be used for other than compare functions. I have never seen code written the way you have expressed it in your question. I would have done it this way:

Select Case TC1

case 0 'actually equals "0"
TracID1 = " "

case is < 27 'catches all instances between "1" and "26"
Do One thing

case is <37 'catches all instances between "27" and "36"
Do a different thing

case 37
TracID1 = ":"

case 38
TracID1 = "."

case else
TracID1 = "$"

End Select

You would place the statements in an order as to catch them in order.

Dave Purola,
N8NTA