probably didn't run it quite as expected, was in the forms VBA and stepping through with F8 could see all the changes in the msgbox and Locals window. It was run without other events being triggered, its a purpose made form that only focuses on the one field that i want to modify.
It is hidden...
result is
UPDATE Table3 SET Table3.Entry = '1/2' WHERE Table3.Entry = '1 / 2'
which to me looks fine.
I feel that this would work fine on a single text entry and not in a long string of text
I stole this from here, thought I could fathom how to adapt it for my use haha
Sub Entry_GotFocus()
'Private Sub ChangeUoM_Click()
Dim db As Database
Dim rs As Recordset
Dim strTABLE As String
Dim strFIELD As String
Dim strOLD As String
Dim strNEW As String
Set db = CurrentDb
Set rs =...