How to generate hyperlinks?

M

mucka

Hi, everybody,
I have such problem:
I want to generate hyperlinks for every patient, so if I have patien
number MRN and I want to generate hyperlink for every patient to folde
which name is the same as MRN (exp: jacket\25647).

What I did, I created Field [PatientJacket] as hyperlink and did updat
query to update PatientJacket field with : 'jacket\' & clinic!MRN

But I got all fields with name of hyperlink (Text to display
'jacket\[MRN]' and with blank hyperlink address value. Do you have an
idea how to update not only hyperlink name, but also address value?

Thank you
 
M

Michel Walsh

Hi,

Depends on the context, but you can try to use # as delimiter between
the 3 parts making the hyperlink.

Hoping it may help,
Vanderghast, Access MVP
 
Top