concatenation

[qwkslvr1999]

I have an ubounded text box in my report that contains a formula like:
[text1] & [text2] & When I preview the report, a # ar...es. Is there a better way to do it? Thanks!

 

[Sohaila Taravati]

Do it in your query behind the report like this:

TextandUrl: [text1]&" "& [text2]&" "& and on your report just call TextandUrl :)

 

[qwkslvr1999]

Thanks! I tried it but it still showed th # sign. Anyway, I tried the hyperlinkpart function and it did the trick!