Display in text box based on selection of List box

[#1]

Hello Friends,

I need to display the selection of List box into a text box.

for instance, I have a lisbox the expression is Monthname(Invoice_Date), If I select Jan 2010 then I need to display in tex box as Jan 2010.

I tried in the text box as Monthname(Invoice_Date), it do show any thing, can anyboady help me.

Thanks in advance.

[Anonymous · Accepted solution]

Did you pick an Invoice date? Otherwise if there are multiple possible values, the text object will show nothing.

If you always want to show the highest possible value you can use Max()

[giakoum]

In the list box you see only 1 value of each month because that is the way the list box behaves. But most likely you have multiple values for dates coming from your data, so use something like maxstring(MonthName(F1)) in your text box to have the desired result.

UPDATE:

sorry Johannes, we both had excellent timing!

[#4]

Hello Johannes and Loannis,

Its really fantastic, thanks a lot both for explanation...

Regards

Chriss