Hi, I have an app sourced from an Excel file on OneDrive. One of the datacards has much more text than the others. I've had to turn Auto height off, as Auto height seems to have a limit that cuts out a lot of the text. Therefore, I've given the datacard a height that is equal to the biggest text feild. The problem now is that the quantity of text for that datacard varies quite a lot, so some searches have an empty white area before the next datacard. Is there any Height code I can use - or any other solution? Thanks!
Solved! Go to Solution.
This might be a bit late but I hope this still helps to other who is facing the same dilemma.
This is how I managed to count the line feed.
Len(Parent.Default)-Len(Substitute(Parent.Default,Char(10),""))+1
Thank you it worked
User | Count |
---|---|
199 | |
102 | |
89 | |
45 | |
43 |
User | Count |
---|---|
246 | |
105 | |
103 | |
65 | |
60 |