x Want to participate? Join the group to interact
Options
  • State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 53 subscribers
  • Views 556 views
  • Users 0 members are here
Browse Forums
Announcements
762
topics
17
replies
Financial year end
77
topics
178
replies
General Discussion UK
7k
topics
19k
replies
General Discussion Ireland
173
topics
308
replies
Install your software
134
topics
367
replies
Making Tax Digital
285
topics
691
replies
Manage your VAT
146
topics
320
replies
Protect and repair your data
43
topics
135
replies
Run your accounts remotely
84
topics
196
replies
Working with the bank
114
topics
292
replies
David Drinkhall

Wordwrap when code more than (x) characters long

SUGGESTED
Posted By

Hi

I'm looking to create a conditional formatting expression where if a stock code is more than x characters (lets say 10) long, then enable word wrap. I know how to enable word wrap, it is the 'if' part of the expression I am struggling with. Does anyone know if / how this is possible?

Thanks.

  • 0
    SUGGESTED

    ** Update **

    Got it to work this morning  on a product list (Shortened the output of Stock Code to 10 characters)

    The resulting code is below.

    if length(Stock.stock_code) > 9 then
    begin
    WordWrap := True;
    AutoGrow := True;
    end

    In the Advanced Filter you type in "length(Stock.stock_code) > 9" without the quotes. Then inythe Properties tab you set the word wrap and auto grow to True


    Does this answer your question?

*Community Hub is the new name for Sage City