sql update of text field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This should be fairly simple, but I'm not seeing the flaw in my code. the
database field is: "planningstatuscomment", the field on the form is
"planningcommenttext" and is unbound. The field content may include special
characters. I've tried variants of:

strsql0 = "UPDATE project SET planningstatuscomment = " &
me.planningcommenttext & " WHERE (project.projectname = '" & Me.ProjectName
& "');"

updates of other non-text fields on the form (dates, checkboxes) are working.

Thanks in advance.....
 
Have you tried using single quotations ' ' around me.planningcommenttext ie;

strsql0 = "UPDATE project SET planningstatuscomment = '" &
me.planningcommenttext & "' WHERE (project.projectname = '" & Me.ProjectName
& "');"
Click to expand...


should allow text and special characters that way, not just numbers.

TonyT
 
Since you're dealing with text, you need to put quotes around the value
you're trying to use for update:

strsql0 = "UPDATE project SET planningstatuscomment = " & Chr$(34) &
me.planningcommenttext & Chr$(34) & " WHERE (project.projectname = '" &
Me.ProjectName & "')"
 
Back
Top