Input Number or Text without dot or commas

[DB_OK]

Hello there,

I am doing an input text (number format) and I need users to only be able to use numbers and not allow them to use dot or commas.

I could use it in text format or number it is indistinct.

I can not figure out how to do it or manage to give it the format so that the user cannot write it and in the case that he can, delete it

[zmansuri · Accepted solution]

Even user types comma as soon as he get out of textbox comma will be removed. You can use it with both

[DB_OK]

I tried with dot but didnt work

[zmansuri]

Set(varTest,Substitute(Substitute(Self.Text,",",""),".",""))