How do I embed hyper text formatting within a text field?

  • Thread starter Thread starter Robert in need of a Guru
  • Start date Start date
R

Robert in need of a Guru

Hello, I am creating a text expression in a query where I am concatenating
fixed text phrases with a data field (eg. "See the picture at
http://picasa.com/rwilliamsfiles/" & [ID]).

Currently, I can not click to link to the desired URL. How do I embed hyper
text formatting for the URL portion of this text expression so I can have a
functioning/clickable URL link in the resulting query?

Help will be deeply appreciated. Thanks.
 
You can use # as delimiter:

"displaytext#address#subaddress#screentip"


(from the Help file)



Vanderghast, Access MVP
 
Back
Top