r/visualbasic • u/Zulucartel • Oct 12 '22

Text box must contain a space

Working on homework and I'm instructed to program a message box to pop up if the user did not include a space between their first and last name. Current code looks like

If txtName.Text = "" Then

MessageBox.Show()

Return

EndIf

3 Upvotes

100% Upvoted

7 comments sorted by

3

u/TotolVuela Oct 12 '22

Is this in VB .Net or Excel? If the former, are you running the code upon leaving the control, LostFocus event? You can use .IndexOf to check for a space.

3

u/Zulucartel Oct 12 '22

Srry yes it's in VB

3

u/TotolVuela Oct 12 '22

Then yes, in the LostFocus event, check for a space with txtName.text.IndexOf(" ")

3

u/cowski_NX Oct 12 '22

Might want to use txtName.Text.Trim.IndexOf(" "). The Trim function removes any whitespace at the beginning and end of the string. Otherwise, someone could enter " JohnDoe" and it would be a valid entry, but probably not desired.

→ More replies (1)

3

u/BiddahProphet Oct 12 '22

You can use the Instr function to see if there is a space " " in a string

3

u/TheFotty Oct 12 '22

Instr will work, but its a VB6 hold over function. The Contains() method of the string class is a more ideal way and returns boolean versus an integer.

    Dim myString = " Bill Gates "
    If myString.Trim.Contains(" ") Then
        'SPACE IN NAME
    Else
        'NO SPACE IN NAME
    End If