Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I searched to make a pop up and the best solution, without a button, is the chr (10) function, but it actually creates a space or character (because it is a chr function) and then values that are null appear (regardless of checking suppress missing/suppress zero-values). I even tried to wrap the code in an if statement, example: if(TotalValue = 0, 0, & char (10)....
Help please
Thank you.
Michelle
Maybe like this: if(len(trim(TotalValue)), chr(10) & 'some text')