Listbox: Assembling columns in a row

[Jack Spratt]

Depending on flags in each incoming database row I'd like to be able to assemble descriptive text alongside other columns taken directly from the database row. Is it possible to intercept the assembly of each listbox row, and insert the descriptive text ?

"Department Head" | Joe Ninety | 456-7890-5657 | 23 Nov 2007

where the db row has a series of yes/no fields: is_dept_head, is_section_head, is_employee, is_retired etc. that are expanded into the descriptive text.


many thanks

 

[Jack Spratt]

The way to do it seems to be in the query using a column expression entered into the query builder instead of a table field name, for example:

Expr1: IIf([is_dept_head],"Department Head",IIf([is_section_head],"Section Head",.......and so on) )

and of course you need all the 'tested' flag columns to be added in to the query builder

So, problem over - hope this helps someone else.