datatype mismatch in vb

[godhulirbalaka]

Hi, I set a table in access first column type number and other text because first column contain item number. and in a form in vb a textbox for item number. so when in run mode i want to search a item by txt_item_number field then it shows data type mismatch. please help me

[debasisdas]

Convert the value to number using val

try to use
val(textboxname .text)