Hi, I'm doing some work for an Access Database but I caught a snag writing an event. I want the event to (among other things) change the Control Source of an object. This is no problem, except I have to set the control source as a string, and the string being an Immediate if function contains a string in it.
Now in C and C++, to write double quotes in a literal constant you just use a backslash infront of it to take it as it is. Such as:
str1 = "President Lincoln said \"Four score and seven years ago...\""
I tried this in my VBA statement and no such luck. It just took the backslash in a string and closed the string at the quotes, like so:
[foo].ControlSource = "=IIf([foo]>0, 100*([foo1]/[foo2]) & \"%\", \"%\")"
So does anyone know the code to accept double quotes in string constants?