Combobox trouble

[Cdogg]

I have a combobox with 3 columns, column 3 is currency. It shows currency in the combobox when I pull it down. When I send it to a textbox it enters it as text. Properties for the textbox is set for currency.

Me!Textbox 1 = Me![Combobox].Column(1)
Me!Textbox 2 = Me![Combobox].Column(2)

I tried this below, but it enters as text and I have 5 combo’s and 5 textboxes . I want the 5 text boxes to show currency, and then I want to total them

Me!YourTxtBoxName = Format(Me![YourCboBox].Column(1),"$#.00")

Thank you for your help

 

[Travis]

Make the Format properties of your text boxes "currency".

Columns in a combo box are "Text" so try this:

Me!Textbox 1 = cCur(Me![Combobox].Column(1))
Me!Textbox 2 = cCur(Me![Combobox].Column(2))

cCur is the function for converting to currency (the type not the format) The format of the text box should then display the value the way you want.