Check if field is Numeric

[eepok]

Hey guys,

Is there a function that would let me know if a field value is purely numeric (no symbols, no letters, no spaces)?

I'm thinking of using in an if/then statement like:

iif([field] isNumeric, "Jump Around", "Ice Ice Baby")

 

[eepok]

Hey guys,

Is there a function that would let me know if a field value is purely numeric (no symbols, no letters, no spaces)?

I'm thinking of using in an if/then statement like:

iif([field] isNumeric, "Jump Around", "Ice Ice Baby")

Ok... I got lucky on this one. I had no idea that "isNumeric" was a function but I searched it out of sheer boredom and it came up.

I would pat myself on the back, but I'm thinking that was sheer dumb luck.

 

[Brianwarnock]

Not really dumb luck, during my career I worked on the principle "how would I have designed it" " what would I have called it" and its amazing how often great minds have thought alike.

Brian

 

[namliam]

Ok... I got lucky on this one. I had no idea that "isNumeric" was a function but I searched it out of sheer boredom and it came up.

And it took you all of 4 minutes...

Sometimes the puzzling Access help is actually .... helpfull