Cut off left-hand side of text in textbox and show only right-hand side (1 Viewer)

[markzaal]

Access 2010

Hi all,

I have a report with some text boxes on it. Sometimes the text in these boxes can be a very long string of chracters (maybe a path to some folder). In this case I do not want the text box to grow. I just want the report to show me the right-hand side of this path and cut off the left.
How do I do this when still aligning my text to the left?

Many thanks!

 

[pr2-eugin]

Could you give a sample Data and what you wish to see as output?

 

[Brianwarnock]

Sometimes I don't understand requests, why insist on aligning to the left if the important bit is the right and you don't mind losing the left,

Brian