Validating the data input does not contain a text character

[Jimmy Buck]

I'm seeking a way to view each character of a field and determine if it's a number or text character - I've made several attempts but have failed to figure it out - I can do the whole field (TextToNum), but not down to the character level?

[comment]

Why not turn on "Numeric Only" in field's validation options?

EDIT:

In case you want to validate by calculation (e.g. in a script), I believe this should work:

Exact ( 1 & Input , TextToNum ( 1 & Input) )

Edited January 6, 2006 by Guest