I am trying to trim all the spaces in a table but I am getting an error.Wonder what I am doing wrong here.
Code:Private Sub Command121_Click() Dim db As DAO.Database Dim strSQL As String Set db = CurrentDb strSQL = " update tbl_Tracking " & _ "set tbl_Tracking = LTrim(RTrim([tbl_Tracking]))" CurrentDb.Execute strSQL Debug.Print strSQL End Sub