Putting combobox info into textboxes

[Cdogg]

I have a combobox with 3 columns, one is currency . When I send it to a textbox it enters it as text. Properties for the textbox is set for
currency .

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

Thank you for your help

 

[R. Hicks]

Hmmm .... your expression does not make sense ...
A Textbox does not have a "Column" property ....

Try this .....

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

(Change "YourTxtBoxName" to the name of your textbox and "YourCboBox" to the name of your combobox)

HTH
RDH

[This message has been edited by R. Hicks (edited 12-23-2001).]