Can the hyperlink property be contingent upon the string value? I have searched this forum but can't find an answer or any coding ideas.
For example, I have a control (text box) in the detail section of a form that's populated by a query/table. For each record, the text box displays a job title, however, some of the stings contain both a title and address to a PDF file containing a job description. Ideally, I'd like the text box to possess the characteristics of a hyperlink (format/handpoint) and function as a hyperlink for those records containing a valid hyperlink, and appear as normal text for those records with only a job title but no description to follow.
Obviously, setting IsHyperlink to Yes on the form's property sheet is "all" or "nothing", so I was trying to apply some conditional logic to effect the characteristics of the text box when the form is loaded. To make things easier, I also have a field in my query/table with the value true/false, indicating whether the text box is a valid hyperlink or not.
...if the form needs to have a text box with two very different things, and space is so tight, what would two text boxes one with the title the other with your hyperlink differ, other than making your life easier? The space between them would be what, a pixel or two. I don't have the vba background, but I bet you can go