Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Dim rs As DAO.Recordset
Set rs=CurrentDB.Openrecordset("NameOfTable")
For i=0 To Len(rs!FieldNameHere)
Debug.Print Chr(Mid(rs!FieldNameHere,i,1))
Next
For i = 1 To Len(rs!FieldName) - 1
Debug.Print Asc(Mid(rs!FieldName, i + 1, 1))
Next
For i = 1 To Len(rs!FieldName)
Debug.Print Asc(Mid(rs!FieldName, i, 1))
Next
Trimmed: Trim(Replace([YourField],Right(Trim([YourField]),1)," "))
UPDATE Table A SET A.Field1 = Replace([Field1],Chr(255),"");
UPDATE Table A SET A.Field1 = Left([Field1],Instr([Field1],Chr(255))-1)