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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count text values in a Access Field 0
Rich Text Format 0
how do I embed a line feed in a memo field via Query 2
How can I create an hyper-link automatically. 0
remove characters from text fields 1
Format for text field 2
parse some text from an inconsistent text field 6
Convert Query field display from text to hyperlink 3

Back
Top