Hyperlink URL appears messed up in Report Preview

[Guest]

Hi,

I have a field in a table using Hyperlink datatype. The URL's entered in
the table appear normal, but in the report's Preview, they appear with pound
signs (##) and sometimes the URL is copied twice in the field. E.g., in the
table, the field contains a hyperlink of "www.hyperlink.com" (without the
quote marks). In report preview, it is displayed as
"www.hyperlink.com#http://www.hyperlink.com#" (again, without the quote
marks).

Can anybody tell me what's causing this, or how to fix it so the url appears
exactly as it does in the table? Or should I just use text data type in the
table? (I'd rather use Hyperlink, so it is click-able).
TIA,
Steve Vincent
(e-mail address removed)

 

[Guest]

Is it possible that you changed the datatype from hyperlink to text?
Double check that the Is Hyperlink property for the text box is set to Yes.
You may need to delete the existing text box and add in a new text box,
setting the controlsource and is hyperlink properties as desired.

I created a test table and form and did not reproduce the problem when the
field's datatype was set to hyperlink in the table. I could reproduce the
problem when I changed the table definition to text from hyperlink and the
changed the text is hyperlink property to No.

Hope this helps...

 

[Guest]

Joy,

That was it! Thank you very much for your help.

Steve