Getting Access to treat text as text

[bravo6]

I am trying to use access to write KML code. There are a lot of lines that are the same for each record and I'm simply adding those lines as text in the field. See example below.

Text1: "<?xml version="1.0" encoding="UTF-8"?><kml xmlns="

http://earth.google.com/kml/2.0">"

I thought that Access should see everything between the outter two " " marks as text. Instead it is breaking the string at each " in the text. Those " within the text are part of the text. Is there a stronger function than " " that absolutely indicates that everything in between those marks are text?

 

[Remou]

As in?

"This is text with ""some quoted text"" contained."

http://lessthandot.com

 

[PHV]

Text1: "<?xml version=""1.0"" encoding=""UTF-8""?><kml xmlns=""

http://earth.google.com/kml/2.0"">"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886