Double quotes

[Rob Berkers]

Hello everyone,

I have a question about the use of a double qoute (").

For an application I need to construct the next XML code:

<item id="311101">

The number 31101 needs to be placed between double qoutes, but in
Access I cannot use the double qoute directly within strings.

I can remember from another language I used in the past that there was
a "enforcing character" that you could use when you needed to have a
reserved character (as the double quote) within a string.

Does Access has also such a enforcing character? Or is there another
way I can use double quotes within a string?

Thanks in advance,
Rob.

 

[RoyVidar]

Hello everyone,

I have a question about the use of a double qoute (").

For an application I need to construct the next XML code:

<item id="311101">

The number 31101 needs to be placed between double qoutes, but in
Access I cannot use the double qoute directly within strings.

I can remember from another language I used in the past that there
was a "enforcing character" that you could use when you needed to
have a reserved character (as the double quote) within a string.

Does Access has also such a enforcing character? Or is there another
way I can use double quotes within a string?

Thanks in advance,
Rob.

You can "double" them up, i e

? "<item id=""311101"">"

or concatenate using the chr$() function

? "<item id=" & chr$(34) & "311101" & chr$(34) & ">"