Hi all,
I would like to format a listbox to display terms with a label like 14 days net, but I do not seem to find a formatting property. Concatination will not do the trick because the field stored would be an integer
SELECT “Terms” || ’ days’, “Term_ID” FROM “tblTerms” this would require a text field which is not practical for calculating a due date after.
Is there a way to format a listbox like a formatted field ?
Thanks
Hello,
Not clear as to the concern. With a list box you can display one thing while storing another. Please provide a more detailed explanation of the problem.
@Rarslinger
Thanks for the quick response. From a terms list-box the user can nominate 7,14, 30 days, so I wonder if there is a way to show x + ‘days’ in the drop-list but only store the integer, because that integer will be used to calculate a due date or return-date. Something I would do easily with formatting in a formatted field # 'days´
Hope this makes more sense from a brain half German, half English and a bit of Spanglish
Oops, sorry for the typo
Hello,
This is all done within the properties of the listbox.
Data tab - Type of list contents =
Valuelist
Data tab - List content = values to be stored within table (each line via Shift + Enter)
General Tab - List entries = what is displayed in listbox (this relates to List content)
Edit:
You can also do this using SQL. If the text & value are in a separate table, the first value in the Select statement is the displayed value. You can set the Bound field to the value (this is relative to 0 so second field = bound field 1).
Thank you very much, much appreciated
