get a specific data in a string

[dada]

hi! let's say i have a record in my table that is "ADRD123", "ABCD12", "TERT321", "ERAR99". what i want to do is just show in my form the numbers only. like for example, "123","12","321","99". is that possible? is there a way to remove the first 4 characters starting from left? please help.. thanks!

[ajetrumpet]

is the record full of string delimted by comma? or are those different fields in the form? are they bound fields or unbound? this all makes a difference. In general though:

to remove the first 4 characters from the left of a string:

right(string, len(string) - 4)

to display numbers only in a string:

dim c as control, i as integer, strOut as string

for each c in me.controls
   for i = 1 to len(c.value)
      if isnumeric(mid(c.value, i, 1)) then
         strOut = strOut & mid(c.value, i, 1))
      end if
   next i
      c.value = strOut
next c

[dada]

thanks! the first one solved my problem..