hyperlinks in HTML report

[steijssen]

Hello,

Does anyone of you gurus know how to set the address property of a table field (type Hyperlink) from within VBA? When I fill the field, it only contains the linktext and not the address. I use
recSet.Fields("path&quot.Value = path
since
recSet.Fields("path&quot.Address = path
doesn't work. (recSet is the recordset I use)
But this only seems to set the linktext, not the address..

When I enter the value manually into the field, it works fine..

Please.. if this makes sense to you.. help!

Oh, could you send your replies to stijn.teijssen@electrabel.com since I can't access this site at work :-(

Thanks a million,
Stijn Teijssen

 

[JoaoTL]

Hi, try this link

http://www.jtl.co.pt/Access/VBA.htm#vba0007

Best Regards

---
JoaoTL
NOSPAM_mail@jtl.co.pt

http://www.jtl.co.pt

http://www.jtl.co.pt/Access