checkbox/textlist problem

[Aussie John]

HI I made a checkbox value list eg 1,2,3

After a number of records had been populated i realised I need to change the valuelist to 1a,1b,2,3

Is there anyway to delete the "1" from the records that are already entered? I obviously cant use the replace option as some records may have 1 and 2 entered and other 1 and 3

Edited September 13, 2006 by Guest

[LaRetta]

You might try:

Replace ( checkbox ; Position ( checkbox ; "1" ; 1 ; 1 ) - 1 ; 2 ; "" )

[Aussie John]

thanks I'll look at that