Godra,
Thanks for looking at this, I added the Else statement then put a breakpoint in the routine. Looking at the Code the Else statement would never be seen as I believe that the "e.Values(0) IsNot Nothing" is never nothing even if the value is a blank field.
I single stepped through more of the program and found in the "Update_Embedded_Variables()" is where what gets displayed is updated per the data from the field. I single stepped around in this loop until I was able to catch what was happening.
In the following code the FinalString does get set to the Blank data as expected but on the next loop is set back to the OriginalString because it is Blank.
If FinalString = "" Then
FinalString = OriginalString.Replace("{#" & i & "}", m_EmbeddedVariables(i).Value)
Else
FinalString = FinalString.Replace("{#" & i & "}", m_EmbeddedVariables(i).Value)
End If
MessageStrings(index) = FinalString
To fix the issue I added this code to the Else portion of the statement.
If FinalString = "" Then FinalString = " "
So far it appears to be working, I used a few characters for the testing but the " " is the end result I needed.
Thanks
Randy