You now have the string broken into smaller parts and the user can type in changes to the smaller section of codes

then Dim myNesString as string
myNewString = text1 & text2 & text3 & text4 & text5

'haven't used ado but I would do it this way with dao

if you are using a databound textbox you would just replace
the text with myNewString and ensure all fields are filled and then
datName.Recordset.Edit
datName.Recordset.MoveNext 'this updates or use Update
datName.Refresh

and you are updated