Search results

  1. C

    trying to type BALLANCE into text field

    Have an odd problem that eludes me at the moment I have table with a text field for surnames and if I type the surname Ballance into the table it automatically reverts to Balance can see no logical explanation for this at the moment funnily it does exactly the same in excel
  2. C

    help with text handling

    Hi Have the following code that works on Access 2000 Dim myForenameBefore As String Dim myForenameAfter As String With CurrentDb.OpenRecordset("Names", dbOpenDynaset) Do Until .EOF myForenameBefore = .Fields("Forename") myForenameAfter = Replace(.Fields("Forename"), "Elizh", "Elizabeth")...
  3. C

    repartial text

    Hi Looking for help with partial text replacement I get various tables with Forenames in them some of which are shortened ie Elizh for Elizabeth, using an update query i can obviously convert all the Elizh's to Elizabeth but when the Elizh appear as the second or third name I am stumped ie...
Back
Top Bottom