Hi,
I'm looking for some advice after trying most of the weekend I just cant seem to get the hang of the @len() & @chr() commands.

what i'm trying to do is, retrive a number of sub records into a single list "vlist" & then pass via xpost to an element in another database via the xpost function.

I can do this however i want to make the list a columnar list so that it is easy to read.


curently my output reads like


123    first item
1234    second item
12345    third item

how I want it to look is


123          first item
1234    second item
12345   third item

my current programing reads (i've italisised the relevant programing)

Var vDescription as string
Var vPos as int
Var vSub as int
Var vSubTotal as int
var vlist as string
var vlen as int

//Loops through the Subrecords
vSubTotal = @FormResultSetTotal("item")     //counts # of records in form/subform
vSub = 1                                    //sets counter to 1
While vSub <= vSubTotal
{
     VDescription = @FormFieldValue("item", "item", vSub)
     vlen=(7-(@len("item#")))      
     FormResultSetCurrentPosition("item", vSub)
     vlist = vlist +               
     
     @FormFieldValue("item", "item#", vSub) + @txt(vlen,@chr(32))+
     @FormFieldValue("item", "description", vSub) +"; " +
     @FormFieldValue("item", "dose", vSub) + "; "+
     @FormFieldValue("item", "offer$", vSub)+ "; "+
     //@FormFieldValue("item", "source", vSub)+
     
     @newline()
     vSub = vSub + 1                   //increases counter value by 1 (see above)
}

FormResultSetCurrentPosition("item", 1)

writeln(vlist)


any advice as to where i'm going off the rails would be most appreciated.