Open Manage | Database | Fields and find the field definition for this field. Might it be defined as a number field instead of a text field?
No, already checked, it's defined as text.
Any chance some other action, such as a triggered script is copying data different from what you copied to the system clipboard?
As a test, I just typed in different mixes of text and numbers into a number field and then copy/pasted from FileMaker 13 to MS Word.
Each time, exact the combination of text and numbers pasted into word as what I copied in FileMaker.
Try a brand new FileMaker file and see what you get if you copy/paste from it to other applications.
I have a feeling that's EXACTLY it, thank you.
Will have to see next time it happens, it only happens with one particular field, which has a script trigger, and the last part of that script is to copy a number.
Thank you, this has been driving me nuts.
Scripts should never be used to copy values to the clipboard unless it is for pasting into other applications. There are better ways to move data around that do not affect what data might be copied to the clipboard.
OK, how would I do that in this case:
I have one table of applications on which I have to make decisions (approve, deny, etc). I have another related table of decisions (an app can have more than one decision since the decision can change later). The script runs OnObjectValidate on the decision field of the application.
Applications have id numbers that are assigned by FM. When creating a decision record, the id on the decision record matches that of the application - the script currently copies the application id, then creates a new record in the decisions table and pastes into the decision id.
Use set Variable in place of copy to assign the ID to a variable.
Use Set field to assign the value of the variable to your ID field in place of paste.
Set Variable [$ApplicationID ; value: Applications::ApplicationID ]
Go to Layout ["decisions" (Descisions)]
Set Field [Descisions::ApplicationID ; $ApplicationID ]
When Setting up Set Field, there are two Specify buttons that must be clicked. To get Set Field [Table::Field ; Expression], add set field to your script and click the first button (specify target field). Select Table::Field from the list of fields. Do not click the specify button next to the repetition box. Click OK to close this dialog box. Now click the lower specify button (calculated result) and create the expression to the right of the semicolon (;). Do not try to type in the semicolon.
Perfect. Thank you!