[AccessD] Interesting behavior with Val()

Because Val returns 0 and the length of "0" is 1.

In the immediate window try: ? val("abc")


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Thursday, November 09, 2006 1:46 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Interesting behavior with Val()


I've read Help looking for an explanation for what I'm about to say, but
haven't found one. 
 
The following expression returns 1 if value has no numeric digits:
 
Len(Val(value))
 
I expected the expression to return 0. You can test this on the Employees
table in Northwind -- there are two records where the Address value is alpha
text, with no numeric digits at the beginning of the value. The above
expression, against those two values, returns 1. 
 
What am I missing? 
 
Susan H.