View last few characters of text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a hyperlink field and the hyperlink are typically rather long (to word
docs). I want to only show the last 15 or so charachters of the hyperlin text
(typically the document name) so that the user has an idea of where the
hyperling is going instead of seeing the first part of the hyperling
(typically /documentsandsettings/...)

Any ideas?
 
In such cases, I sometimes use InstrRev to find the position of the last
slash in the string, then Mid to extract the string beginning one position
further.
 
I have a hyperlink field and the hyperlink are typically rather long (to word
docs). I want to only show the last 15 or so charachters of the hyperlin text
(typically the document name) so that the user has an idea of where the
hyperling is going instead of seeing the first part of the hyperling
(typically /documentsandsettings/...)

Any ideas?
Click to expand...

You can change the displayed text directly in the table field.
Right click on the hyperlink field.
Select Hyperlink + Display Text.
Simply write in what you wish to have displayed.
 
Back
Top