enabling a command only after text boxes are filled

[dibya11]

I need to enable a command button only after three text boxes are entered text into.Where do I write the code and what do I write. Please help.

 

[Leoncito]

you can try use the Validate event for each textbox, and need a boolean variable to enable the command
Set the TabStop property for the textboxes to True and the TabIndex property:

Private Form_Load()

Text1.TabIndex=0
Text2.TabIndex=1
Text3.TabIndex=2

End Sub

Private Sub Text1_Validate(Cancel As Boolean)

If Text1.Text="" then Cancel=true

End Sub

Private Sub Text2_Validate(Cancel As Boolean)

If Text2.Text="" then Cancel=true

End Sub

Private Sub Text3_Validate(Cancel As Boolean)

If Text1.Text="" then Cancel=true
Command1.Enabled=True

End Sub

This doesn´t prevent syntax errors, just checks the TextBoxes aren´t empty. If you want to Know more check Validate Event for TextBox in MSDN

 

[JohnYingling]

In every form, I put in a sub called AdjustControls.
Private Sub AdjustControls()
I call this from every event that might affect other controls.

Call this from each Text_Changed Event
Private Sub AdjustControls()
cmd.Enabled = (Len(txt1.Text) > 0 and _
Len(txt2,text) > 0 and _
Len(txt3.Text) > 0)
End Sub

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing Control

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript

 

[JESTAR]

This is another way.

[tt]
Private Sub cmdDone_Click()
Dim ctl as Control

For Each ctl In Controls
If TypeOf ctl Is TextBox Then
If ctl.Text = "" Then
MsgBox "All fields must be entered."
Exit Sub
End If
Next ctl
[/tt]

 

[dibya11]

Thank you all for your helps.
It worked all the ways.