VB - proper format for this IF statement Follow
Till today, I have gotten away with having a Single Line Expression for my "SetTrack" field.
The expression was simply:
Format.NamedSubStrings("PMSetID").Value & " " & Format.NamedSubStrings("SetID").Value & "/" & Format.NamedSubStrings("TrackID")
However, I am now in need of making an adjustment. It PMSetID and SetID are the same, Id like to continue down that path, but if different, id like to make an adjustment. I cant quite figure out the format here. I have the following, any thoughts would be appreciated.
PM = Format.NamedSubStrings("PMSetID").Value
SET = Format.NamedSubStrings("SetID").Value
If PM = SET
Format.NamedSubStrings("PMSetID").Value & " " & Format.NamedSubStrings("SetID").Value & "/" & Format.NamedSubStrings("TrackID")
Else
Format.NamedSubStrings("PMSetID").Value & " " & Format.NamedSubStrings("TrackID")
end if
2 comments
In case anyone else finds it helpful, I believe I have it working
PM = Format.NamedSubStrings("PMSetID").Value
SET_ID = Format.NamedSubStrings("SetID").Value
If PM = SET_ID Then
Value = Format.NamedSubStrings("PMSetID").Value & " " & Format.NamedSubStrings("TrackID")
Else
Value = Format.NamedSubStrings("PMSetID").Value & " " & Format.NamedSubStrings("SetID").Value & "/" & Format.NamedSubStrings("TrackID")
End If
Hi Brian!
Welcome to the BarTender Community!
Thank you for sharing with us the solution you found for this issue! People with the same query will surely find it useful. :)
Please sign in to leave a comment.