>Keith,
>
>You don't have to go through as much work as you are. VAL() stops at the first non-numeric character it finds.
>
>? val( "1234 Main" ) && 1234.00000
>? val( " 1234 Main" ) && 1234.00000
>? val( "POBox 1234" ) && 0.00000
>? val( "1234 E 5th" ) && 1234.00000
>? val( "1234E5th" ) && 123400000.0000
>
>In the last example E5 means 10^5
>
>>I'm posting this fragment to see if there's
>>something obscure that I'm missing about the
>>VAL() function.'
>>
>>THIS CODE basically JUST makes sure that the
>>FIRST "word" OF an address IS a numeric VALUE
>>greater than zero. Everthing seems TO WORK
>>fine until you het the VAL() FUNCTION.

Hey David,

Yeah I know all of that. There are two problems. One is that
let's assume that the address is

1234 E 125th St.

In this case the only generic rule that you can use that will work
is to get the value of the first word.

The problem here is obvious (I think).

The other, bigger problem is the C5 error. I have a call into MS and
have been really impressed with the support person that I've been in
touch with thus far.