VBA in access...IF THEN ELSE

Question

I am trying to make a conditional statement that will basically say if field1 + field2 = "string" then do some stuff... i am pretty sure i have the stuff part right but i dont think i have the conditional statement correct... this is what i have

txtTeam.Visible = True
If ([GuestFirstName] + [GuestLastName] = "Angela Cockrill") Then
    [LifetimeTxt] = "Trips of a Lifetime!"
    txtTeam.ForeColor = vbOrange
    txtTeam.FontSize = 14
    txtTeam.FontBold = True

Else
    txtTeam.Visible = False
    txtTeam.ForeColor = 0

End If

Pepto · Accepted Answer · 2014-05-06 04:49:50Z

1

In MS Access VBA I would use the ampersand operator & to concatenate 2 strings together, not the plus sign but that's just a preference. You also may need to account for the space e.g.

txtTeam.Visible = True
If ([GuestFirstName] & " " & [GuestLastName] = "Angela Cockrill") Then
    [LifetimeTxt] = "Trips of a Lifetime!"
    txtTeam.ForeColor = vbOrange
    txtTeam.FontSize = 14
    txtTeam.FontBold = True

Else
    txtTeam.Visible = False
    txtTeam.ForeColor = 0

End If

edited May 6, 2014 at 4:49

answered May 6, 2014 at 4:41

Pepto

1,44410 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Simon1979 · Accepted Answer · 2014-05-06 04:42:44Z

0

Depending on what you have in your fields you probably need to add the space, as well as use ampersands:

If ([GuestFirstName] & " " & [GuestLastName] = "Angela Cockrill") Then

answered May 6, 2014 at 4:42

Simon1979

2,1081 gold badge12 silver badges15 bronze badges

Collectives™ on Stack Overflow

VBA in access...IF THEN ELSE

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related