Skip to main content



Check first character is it letter or number


1 comment

  • Avatar
    Peter Thane

    You need to use the IsNumeric command I believe and have code like this

    Value = Format.NamedSubStrings("theinput").Value

    Value = left(Value,1)

    Value2 = IsNumeric(Value) 

    Value = Value2 

    If Value2 = -1 then 
    Value = "AMG" 
    else Value = "A"
    end if

    Value = Value


    Depending on when your data is being added to the label you may need to make this an EventControlled VB script routine and process it OnNewRecord if from a Database or OnPostPrompt if from a Data Entry Form etc


Please sign in to leave a comment.