By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,688 Members | 1,877 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,688 IT Pros & Developers. It's quick & easy.

RTF Export: Want to display text, not invalid hyperlink message

BBM
P: 4
I have an Access database of documents, with hyperlinks to PDFs. Sometimes I need to reference a document for which I don't yet have a PDF, so I type the name of the document into the hyperlink field in parentheses. This works great when I export to an Excel file, because the name I've given the missing document shows up and it is obvious that it is not an active link because of the parentheses.

But now I need to export to RTF, and instead of displaying my text in parentheses, I get "Error! Hyperlink reference not valid." Is there a way to make my RTF display the text of the invalid hyperlink instead?
Sep 26 '06 #1
Share this Question
Share on Google+
5 Replies


PEB
Expert 100+
P: 1,418
PEB
Hi,

Why don't you organize your Mail Merge from Excel in this case?

:)
Sep 26 '06 #2

BBM
P: 4
BBM
Thank you for your help.

Is mail merging different than exporting? Sorry if that is a stupid question but I'm a paralegal, not an Access expert! :-)

I can't export to Excel because I have a memo field with very lengthy text, and Access outputs reports to Excel 5.0/95 format, which truncates text-cell contents at 255 characters.
Sep 27 '06 #3

BBM
P: 4
BBM
I guess no one can help me .... ?
Sep 28 '06 #4

PEB
Expert 100+
P: 1,418
PEB
Hey man,

And what about to remove the non active hyperlinks... In meaning that they are in your database but for your query that is used to export the information to RTF the hyperlinks with brackets aren't visualized?

Is this a solution for U?

Best regards!

PEB

:)
Sep 30 '06 #5

BBM
P: 4
BBM
No can do PEB. That is the crux of the problem; rather than display the text of the inactive hyperlinks, I get the message that the link is invalid. But I have to be able to see the text that I typed in.

What I'm think I'll have to do is create another, non-hyperlink, column where I can type the text again, and export that as well.
Oct 6 '06 #6

Post your reply

Sign in to post your reply or Sign up for a free account.