hi,
how to make valid only digits in ms access text control?
[txtproductid]
hi,
how to make valid only digits in ms access text control?
[txtproductid]
Hi
You could try setting the "Format" property of the textbox to something like General Number.
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
actually ,i want if input except digits event should be cancel
exactly this function " Is Null OR Not Like "*[!0-9]*" " but in vb code
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.
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick