I need to assign a length of an Text box to an object for validation purposes. I know this is not that hard but I have had a long weekend and can't think today...thanks for any suggestions...
dim intcheck
If Form.purchaseprice1.value = "" then
'Elseif Form.purchaseprice1.value
MsgBox "Please Enter a valid Purchase Price. No $ or - (XXXX.XX)"
Form.purchaseprice1.focus()
Exit Sub
Else Len(Form.purchaseprice1.value) > 11
document.write Len(Form.purchaseprice1.value)
intcheck = = Len(Form.purchaseprice1.value)
'MsgBox "Please Enter a valid Purchase Price. Can only be 11 numbered digits long."
Form.purchaseprice1.focus()
Exit Sub
This is what I have so far...again thanks
dim intcheck
If Form.purchaseprice1.value = "" then
'Elseif Form.purchaseprice1.value
MsgBox "Please Enter a valid Purchase Price. No $ or - (XXXX.XX)"
Form.purchaseprice1.focus()
Exit Sub
Else Len(Form.purchaseprice1.value) > 11
document.write Len(Form.purchaseprice1.value)
intcheck = = Len(Form.purchaseprice1.value)
'MsgBox "Please Enter a valid Purchase Price. Can only be 11 numbered digits long."
Form.purchaseprice1.focus()
Exit Sub
This is what I have so far...again thanks