CODEWITHSUNDEEP
ms-accessms-access-2007vba
user3241316
user3241316

Reputation: 167

If Then statement not returning as expected

Where did I mess up this syntax? testname is returning as an empty string. TestType is a Combobox, and TestType.Value in this case is "TE" (confirmed with the debugger)

Dim testname    As String
If Not IsNull(TestType.Value) Then (testname = " & TestType.Value & ")

Upvotes: 0

Views: 49

Answers (1)

Brad
Brad

Reputation: 12255

I'm surprised this even ran for you. I can't get it to compile. You can't wrap an entire line in parentheses.

If Not IsNull(TestType.value) Then testname = " & TestType.Value & "

Upvotes: 1

Related Questions