VBA validation

[Pritul]

Im having a problem, its been sort of bugging me out.
If a user does not enter a value in a textbox on a form, I want to display a erroe message. A sort of validation.

I have tried loads of thing, one is:-

If stockpricet.val ue = " " Then
MsgBox "Value not entered"
End If

can any body help?

Pritul

[Mahi]

U can check it on the text box leave event or on the submit button on the form

[Pritul]

Thanx

U can check it on the text box leave event or on the submit button on the form

Well I tried to check it on the submit button, it just does not seem to work.

What leave even, I havent seen that on VBA yet?

[Gautam Dasaka]

If stockpricet.tex t = "" then
Msgbox "No Value"
endif

or

if stockpricet = "" then
Msgbox "No Value"
endif

Perhaps these will work.

Regards

[RioDog]

Im having a problem, its been sort of bugging me out.
If a user does not enter a value in a textbox on a form, I want to display a erroe message. A sort of validation.

I have tried loads of thing, one is:-

If stockpricet.val ue = " " Then
MsgBox "Value not entered"
End If

can any body help?

Pritul

You need to do this in the before update event
Try this
if isnull textbox(name) then
cancel = true
msgbox.....
set focus to textbox
end if
or this
varible name = Trim$(txtbox(na me))
If Len(variable) = 0 Then
MsgBox
Cancel = True
end if

Hope it helps!!!