Hi 

I throw an error message when trying to calculate km from m input from an Excel data base.  The dB field is named Length.

I created a new field on the label.  Data type - I set to Number.  Data Source I set Type: Visual Basic Script.  Script Type: Event Control Scripts.

In the editor, on OnAutoSelectedEvent, I entered Value = "10000" as a place holder.  Then, on OnNewRecord, I entered Value = and double clicked the Length field from Database Fields, on the right.  This filled in Value = Field("ExcelLabel.Sheet1.Length").  On a new line, I entered Value = Value / 1000.  Closed the editor, then clicked Preview.

Error: BarTender Warning Message #3912.  Field Name ExcelLabel.Sheet1.Length has not been declared.  To declare a field, insert ReferenceField("ExcelLabel.Sheet1.Length") at the top of your script.  So, I did that.  Preview again, new error.

Error: BarTender Warning Message #3912  OnNewRecord(Line2): Field name ExcelLabel.Sheet1.Length was not found.

I am puzzled since I used an existing data base field name.  The Excel file has four records with data in each for Length.  I test printed Length in meters from the data base yesterday.  I welcome your comments.  Thank you!

Steve