So basically in this database there are random numbers that are some times 4 characters long and sometimes 5 characters. I tried to make a replace function like this:

VB Code:
  1. Private Sub Form_Load()
  2. On Error GoTo move_first
  3. Do
  4. If GIS.Value = "xxxx" Then
  5. GIS.Value = "R00000" & GIS.Value
  6. ElseIf GIS.Value = "xxxxx" Then
  7. GIS.Value = "R0000" & GIS.Value
  8. Me.Recordset.MoveNext
  9. End If
  10. Loop
  11. Exit Sub
  12. move_first:
  13. Me.Recordset.MoveFirst
  14. End Sub

Anyways, this just hangs the program and forces me to do a ctrl + alt + break

if anyone has any ideas, they are greatly appreciated