I have changed an input field to a dropdown. I am loading the dropdown from a database table.
I need to show more than one field in the list of values that the user selects from, so I have an expression in the "choice options field" propery:
Code: Select all
LTRIM(DIGITS(ORDNO), '0') CONCAT ' ' CONCAT SHNAME CONCAT ' ' CONCAT ADDUSER
Since SHNAME is fixed-length character, the ADDUSER values should align, and they do in Run SQL Statements.
![Screenshot 2023-11-02 150154.png](./download/file.php?id=1723&sid=472ae6872272f9c999df54828c495566)
- Screenshot 2023-11-02 150154.png (15.34 KiB) Viewed 24828 times
But not in Genie.
![Screenshot 2023-11-02 150526.png](./download/file.php?id=1724&sid=472ae6872272f9c999df54828c495566)
- Screenshot 2023-11-02 150526.png (5.62 KiB) Viewed 24828 times
Is there a way to keep the whitespace?
Thanks in advance.
Ted