I currently have programming in Vendor Name on element entry that populates the field with a listing and when a selection is made appears as follows prior to exiting the field:

Joe Element - Expenses - 63

In Vendor Name, on element change, the following programming strips out everything but the vendor name (Joe Element) and selects the vendor # (63) at the end of the statement:

Vendor# = @Right(VENDOR NAME, 3)

Vendor Name = @LEFT(VENDOR NAME, @INSTR(VENDOR NAME, "-") -2)

Up until now, everything was working fine until I selected a vendor that had a number less than 10.  It still returns the proper vendor name but does not recognize the vendor # and defaults to 0.

Do you see anyway to fix this ?

Thanks,

Louis

When doing the processing,

1.  Make a variable of the field content.
2.  Change the first  hyphen to a tilde
3.  When getting Vendor# use @Right with the hyphen as a reference to grab from

var vTemp as String

vTemp = @ReplFir(VENDOR NAME, "-", "~" )

Vendor# = @Right(vTemp, @Len(vTemp - @InStr(vTemp, "-") +1 )
VENDOR NAME = @Left(vTemp,@Instr(vTemp, "~") -2 ) 

Note, this is untested code off the top of my head.



----------
Edited to include missing last line.

Here's the more subtle approach:

var vVal as String

	vVal =  VENDOR NAME
	vVal = @Replace(vVal, " - ", ";")
	VENDOR NAME = @AccessStringArray(vVal, 1)
	VENDOR# = @AccessStringArray(vVal, 3)