i want spaces in a table using a updatequery

[ice-9]

hi,

I want to put spaces in a table. With spaces i mean for example: i have the word "hallo" and i want it to be writen in the table as: "____h____a_____l_____o"
the _ are spaces. I have the string perfectly in a variable. But when i add it to the updatequery i get an syntax error on the string.

I used the following query:
cnn.Execute "UPDATE Minutes SET Minutes.MinutesID = " & strFinal & " WHERE (Minutes.MinutesCode)= " & [Forms]![MinutesMF]![itemlist].Column(4) & ";"

 

[FoFa]

Single quotes around the value are required (string).
cnn.Execute "UPDATE Minutes SET Minutes.MinutesID = '" & strFinal & "' WHERE (Minutes.MinutesCode)= " & [Forms]![MinutesMF]![itemlist].Column(4) & ";"

You may also need the single quotes around the [Forms]![MinutesMF]![itemlist].Column(4) if it is a non-numeric value also