Form List/Combo Box with formating and multilines

[Quordlepleen]

I am creating a fillable form using list and combo boxes that are taking entries from spreadsheet. I am trying to figure out if its possible to apply any formatting or line breaks to entries in the list. Some of the entries will be drawing from several cells from the spreadsheet and I want the single list entry to be displayed over multiple lines such as:

A2
B2
C2

Unfortunately my attempts to format in calc such as using “=A2&CHAR(10)&B2&CHAR(10)&C2” don’t transfer to the list box and just comes out as A2B2C2. From what I can tell its only the text box forms that have any options for formatting but not for lists that draw from a spreadsheet. Is there a way to format list box entries?

[RobertG]

No chance to get a formatted content fore more than one row in list boxes or combo boxes. It will only be possible in textboxes - and there also only for line breaks. If you try to line breaks and formatting there the textbox will lose the connection to the data source, because the formatting can’t be saved.