validation; allowed only digits in text control?

[alex_raju]

hi,



how to make valid only digits in ms access text control?

[txtproductid]

[Bob Fitz]

Hi
You could try setting the "Format" property of the textbox to something like General Number.

[alex_raju]

actually ,i want if input except digits event should be cancel

[alex_raju]

exactly this function " Is Null OR Not Like "*[!0-9]*" " but in vb code

[Bob Fitz]

Hi

In that case I would use the BeforeUpdate event of the textbox. You may want to use the inbuilt functions IsNumeric and IsNull to check what has been typed into the textbox and set Cancel if they return false.