Hyperlink Expression syntax

[tvshmat]

Hi there! What would be the syntax in hyperlink expression to include path to a folder named Departments' Rox(Departments' Rox/gldetails.rox?...)? Tried to use single and double quotes, but still getting an error.

Thanks in advance,
T

 

[bcaslow]

You actually have a single tick in the folder name, Departments'?

 

[tvshmat]

The folder name is "Departments' Rox

 

[bcaslow]

Hmm, I dunno if the single tick will cause you problems or not. I usually put at least one set of quotes round the value that I search for. Also, you have to double the quotes inside a string, which I don't know if you're using or not. Just use the relative path name; for example, if you were creating a dynamic hyperlinked contact report:
"detail.rox?ContactID=""" & [ssId] & """"

 

[tvshmat]

Thanks, bcaslow, I'll try it.