Search for text characters

[bakerld]

I've been programming Access Dbs for a long time (I used to be XLEAccessGuru on this forum, but I totally lost my login info and can't get it back cause I forgot my old email address!), but I'm having a brain train wreck right now and can't remember how to do this. I searched and searched but can't find what I'm looking for... so sorry if this is a repeat.

In a control, on the beforeupdate Event, I'd like to validate that there are no letter characters in the text the user entered. I cannot change the data type to a number field this a multi-user program being converted from a really old Excel program. I can't change the field data types or it will cause cascading issues throughout the workflow database. I've had to come up with some pretty creative programming to get around these issues.

So anyway, what's the built-in VBA function/method (or is there one?) that I'd use to tell me if there are letters contained in the text box? If there are no methods that exist in the VBA lib to do this, does anyone have a custom function you could share to help me out here?

I know this is probably basic, but like I said, I'm wrecked today for some reason and drawing a blank.

Any help is appreciated. Thanks!!

-L

 

[KeithG]

would the IsNumeric function suite your needs? This will make sure the value is a valid number

 

[boblarson]

If it has to be numeric then you can use the

IsNumeric(YourFieldHere)

function

 

[bakerld]

Cool!

I knew it was a no-brainer. Thanks for your help Bob!

 

[boblarson]

I knew it was a no-brainer. Thanks for your help Bob!

And Keith

 

[bakerld]

you too Keith!