Currency Issue

[Shooting Star]

Hi,

I have a list box, with two columns: The first has the name of a carpet, and the second has the price. I have a textbox which looks up the price of the carpet selected:

E.g.
[Listbox].[Column](1)

However, the textbox shows the value of the carpet, but not the £ sign next to it. The column with the price is set to Currency data type in the table, and the textbox is set to currency.

Please help!

 

[pbaldy]

Try

=Format([Listbox].[Column](1), "Currency")

 

[Shooting Star]

Thank you so much, it works perfectly now!