Access truncates field values in CFOUTPUT 1

[brian1313]

I'm using ColdFusion to fill in form entries in an update database application. Everything is working fine except when I have a multi word value in a field. The form only displays the first word. Is this an MS Access problem or a CF problem?
Thanks in advance
-b-

 

[kingjjx]

Check your script and the datatype of the field you are trying to input.

 

[jls]

Try using single quotes around the field like '#MyVar#'

 

[brian1313]

thanks JLS, that worked perfect!! i never even thought of that...