Hyperlinks in table 1

[OzFoxy]

Table Name: Fixtures
Field: Report (data type is Hyperlink)
I have the following code which puts the hyperlink (text?)into the field.
rstFixtures!Report ="#

http://www.armygolfclubwa.com/reports/081217.htm#"

I create a report from the table, and output that to a HTML page, and the link works fine when clicked.
The text that appears in the table field, on the report, and the web page, is the URL.
If I manually edit the field in the table (right click, hyperlink, edit hyperlink) I can set the 'Text to display' property to 'Match Report', then that displays in the report and on the web page.
My question is: Is there any way of setting the text to display property of the (table) field in VBA?
Hope I have provided sufficient info.
Thanks in anticipation.

 

[PHV]

rstFixtures!Report = "Match Report#

http://www.armygolfclubwa.com/reports/081217.htm#"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[OzFoxy]

Fantastico. That's about the only thing I didn't try. And my first reaction on seeing the solution was that I had wasted several hours on this, but then realised that along the way I had read lots of stuff from help, lots of other posts, and that in reality it was a learning journey.
Thanks very much.