如何保存超链接的标题,与超链接本身不同? [英] How to save a Caption for a Hyperlink, different from the Hyperlink itself?
问题描述
我正在尝试创建一个表单,用户输入文档引用号,然后单击命令按钮,通过文件选择器添加文档的超链接。
感谢Adezii的优秀文章 http:// bytes。 com / topic / access / answer ... ink-into-table 我可以设法创建一个指向文档的超链接并将其存储在表中,但它是完整的超链接路径而不是文档的引用号显示。
目前我有一个解决方法,我在第二个文本框[HCaption]上覆盖了超链接[Hlink]。如果我在[HCaption]框中键入我的文档参考,然后单击命令按钮我可以通过修改Adezii的代码,以编程方式将标题添加到所选项目以创建超链接。
I''m trying to create a form where a user enters a document reference number and then clicks a command button to add a hyperlink to the document, via a file picker.
Thanks to Adezii''s excellent article http://bytes.com/topic/access/answer...ink-into-table I can manage to create a hyperlink to the document and store it in the table, but it is the full hyperlink path not the reference number of the document that is displayed.
I have a workaround at present, where I have overlaid a second textbox [HCaption] over the one holding the hyperlink [Hlink]. If I type my document reference into [HCaption] box, then click the command button I can programatically add the ''caption'' to the selected item to create the hyperlink, by modifying Adezii''s code as below.
推荐答案
我觉得这很有趣,因为我还没有使用超链接。我今天或明天要测试一些东西并回复你。
I find this interesting, since I haven''t used hyperlinks yet. I''m going to test some things today or tomorrow and get back to you.
@sierra7
你好sierra7,我没有问题实现这个逻辑。 [HLink]的控制源是超链接数据类型吗?
@sierra7
Hello sierra7, I had no problem implementing this logic. Is the Control Source for [HLink] a Hyperlink Data Type?
这是我如何工作的。使用未绑定的文本框(txtLink)设置
显示为超链接=如果超链接
我有一个按钮:
Here''s how I''ve got this working. With an unbound textbox (txtLink) set
Display As Hyperlink = If Hyperlink
I have a button for:
这篇关于如何保存超链接的标题,与超链接本身不同?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!