Help! Validate A Textbox? :huh:

[BlackMantis]

Hey B1,

I ran into a little bump in the road. I am implementing a form in access.. Basically, I have a print button on the form as well as a text box. what I want to do is to send an error message when I click print if the text box is empty and cancel the print job. this will ensure I have a value in the text box. Can someone assist me in this code for the print button?

Thanks

[Gfields]

You could try this. Don't forget to change the relevant bits

Quote:

Private Sub CommandButton1_Click()
&nbsp; &nbsp; If TextBox1.Text <> "" Then
&nbsp; &nbsp; &nbsp; &nbsp; DoYourPrintThing
&nbsp; &nbsp; Else
&nbsp; &nbsp; &nbsp; &nbsp; msg = MsgBox("You need something in the textbox", vbCritical + vbOKOnly, "Warning")
&nbsp; &nbsp; End If
End Sub

[PCTech]

i've always used this in visual basic

Code:

...
if trim(textbox1.text) = "" then
     msgbox "you need to enter something in the textbox!"
else
     doprintfunction() '/ your print function code here
end if
...

Similar to the above, but its just what i've always used