Change: Set Field [MyDatabase::TextField; MyDatabase::TextField + "," + MyDatabase::DifferentField]
To: Set Field [MyDatabase::TextField; MyDatabase::TextField & "," & MyDatabase::DifferentField]
It was adding because you are telling it to add by using the "+" sign. Use "&" to concatenate.
Al is correct! "&" is the proper concatenation symbol for TEXT.
However, had you used this:
MyField + ",1"
and it was a number, I believe you would have gotten the correct results. Or perhaps this:
GetAsNumber(MyField) + ",1"
(not confirmed, so you'll need to test)
Thanks Allen, I appreciate your taking the time to set me straight on this.
Thank you too Beverly, I learned two useful syntax tips for the future from your post, also.