HTML Exporting - How to Change Display Name

  • Thread starter Thread starter MeTed
  • Start date Start date
M

MeTed

Hey All,

I currently have a routine that creates a table with a hyperlink reference
to a network location (ACC2003). This hyperlink ends up being lengthy once
I export this table to HTML. Is there a way in the export routine to give
the hyperlinks a "friendly" name? This name would actually be data from
another field.

For instance:

Field1:
087-3334

Field2:
\\server\projects\year\client\part\revision\blahlahblah


When I export I want the "087-3334" to hyperlink to Field 2's location.


Thanks in advance....
 
Hi,

At least in Access 2003, if you have a Hyperlink field containing a
string formatted like this:

displaytext#address#subaddress

when you export to HTML it is converted into a HREF structure

<A HREF="address#subaddress">displaytext</A>

So the simplest thing may be to combine your two fields into one and
take advantage of this behaviour.

Otherwise, all I can think of involves hand-coding:

(a) write VBA code to generate custom HTML, or

(b) do a standard export to HTML and then have your code run through the
resulting file to modify the links as required.
 
Back
Top