msgbox

[sjdth]

If I've wrong entered some words into a text box in a form which that text box's data type was set to number, there will be a defalt msgbox pop up indicated that "the value you enter isn't valid for this field......."

How can I get rid of this msgbox and replace my own msgbox

Thanks alot!!

sjdth

 

[llkhoutx]

One way is to trap the error number you're getting (Err.number) and test for it to print your own message.

 

[sjdth]

llkhoutx

Can't do, the ms access msgbox does not have that err.number or 'Help' button

sjdth

 

[ahvc]

validation rule/text

One way I know can be done is through table deisgn with the validation rule and validation text values.