Show second column of 2 column listbox in report text box

[Frank72]

Hows it going

I want to put a date at the top of a report, simple enough but the date i want to show id the second column of a double column list box and therefore the index is being shown, ive tried [forms]![frm]![listb.column(2,comb.listindex)]
this seemed like a long shot but there must be a way of getting the second column to show in the report text box. obviously i cant change the bound coluimn cos its needed for various other operations

any ideas gratefully rceived


Thanks

 

[pdldavis]

Hi, you might try this:

=[listboxname].[column](1)

-Which displays the second column of the list box. (0) displays the first.

 

[ChrisBelzona]

I know this is not pretty but To get around this problem, you could create a Textbox on your form to and update it with the column value you want using the afterupdate event and then reference that from your report.

As I said not pretty.

Chris