I'm using unbound forms which use code to load data from tables and/or queries into the forms' various controls, mostly being textboxes. Currently I have a Access 2000 mdb but expect later to move to SQL Server, and thus want to store hyperlinks as text data types rather than hyperlink data types (trying to reduce conversion headaches later). I can't seem to get the hyperlinks to work. Here's what I've done:
- I set the textbox's IsHyperlink property to True.
- The textbox is unbound.
- I make the hyperlink value assignment to the textbox in code, in the form of:
.... code gets hyperlink value from table...
Me.txtHyper = "Wyatt#mailto: Wyatt@anyplace.com"
- The textbox displays "Wyatt#mailto: Wyatt@anyplace.com" in blue underline, like a hyperlink. But it doesn't display the "Wyatt" part alone as it normally should.
- When I go to the textbox, the pointed-finger icon doesn't appear and when I click nothing happens.
FYI, I've tried different variations of the hyperlink syntax, all with the same results.
Any ideas on where I'm going wrong?