How to limit length of string/text shown?
Hey guys, I want to achieve the following: instead of showing "Depreciation and Value Cost Estimate", i only want to show the first 10 letters, "Depreciation".
How can i achieve that? One post mentioned : Set(MaxValue, 40), however it is intended for text input.
But mine is not user text input, it is directly from my data source.
In addition, Len(mytext) only get me the number of char i have, but it doesnt achieve my goal.
Solved! Go to Solution.
How about Left(mytext,10)
Hey it worked like a charm!
User | Count |
---|---|
254 | |
106 | |
92 | |
47 | |
37 |