Not displaying whole hyperlink in report field (2000 (in 2003))

Topic

New Reply

I have a report which displays a field which is formatted as a hyperlink. Unfortunately it displays with the contents of the field and the hyperlink “April Document List #AprilDocs20050404” when all I want to see is “April Document List”. It looks fine in the query (except for the underline).

How can I display the field contents as I required please?

Thanks
Roberta

Reply | Quote

Replies

What is the Control Source property of the text box that displays the hyperlink field?

Reply | Quote

the control source is the field from the query my report is based upon. The query uses the table field (doc Name) which is a hyperlink field. So viewed in a table or form it says e.g.”April Document List” (naturally in blue and underlined) – but for some reason in a report it picks up the hyperlink file name as well?

Reply | Quote

That’s strange – hyperlinks display “normally” in reports for me. Could you post a stripped down copy of your database, with just enough left to demonstrate the problem? See post 401925 for instructions.

Reply | Quote

herewith cut down version.
Just with tables
query and report

Thanks for your help
roberta

Reply | Quote

Something seems to have gone wrong – there’s no hyperlink field in any of the tables, and no report.

Reply | Quote

Opps – try this one –

Reply | Quote

It seems to work OK in a report based on the table or on a query based on the table (only), but as soon as the query is based on more than one table, things go wrong. I don’t know why that happens, but here is a workaround:
– Change the name of the DocumentType text box on the report to (for example) txtDocumentType.
– Set the Control Source of the text box to

=IIf(Not IsNull([DocumentType]),Left([Documenttype],InStr([DocumentType],"#")-1))

This extracts the first part (the display text) from the hyperlink field if it isn’t empty.

Reply | Quote

Many thanks – this has worked brilliantly. This has got me some brownie points ahead of my 3 month appraisal tomorrow!!
Regards
Roberta

Reply | Quote