Hyperlinks

S

simplymidori

Let's say I have a list of hyperlinks in a column

Column A:
Link: "ftp://upload:[email protected]/spot%20viewer/" & [number] & ".wmv"

Column B: [number]

I want column [numbers] as text to display.

Thanks in advance.
 
J

Jeanette Cunningham

Try this:

Me.BTextBox = Me.ATextBox & Me.BTextBox & ".wmv

BTextBox is the name of the control on your form that is bound to field B
[number]
ATextBox is the name of the control on your form that is bound to field a
[number]

Jeanette Cunningham
 
Top