combobox column format lost when added to textbox

[pas123]

I have a form with a combo box and a text box. The combo box uses a query with 6 fields the 6th one is currency. The text box's control source is the combo box's column(5). When a selection is made in the combo box the text box does not display currency. ie text box should be $1.10 and is 1.1
Is there a way around this problem?

Thanks
Paul

 

[boblarson]

You have to set the format of the text box to currency. Formats do not carry over from controls.

 

[pas123]

yes and I tried seting it to standard with 2 decimal places.

 

[Rich]

Standard is not Currency

 

[pas123]

Yes I know....I have just tried to make the texbox display 1.00 in any way and it won't. All it will display is 1

 

[boblarson]

can you post your db here?

 

[RoyVidar]

Try make the controlsource

=Val(theCombo.column(5))

in stead of

=theCombo.column(5))

See, anything but the bound column, I think, is considered text, so I think you need to convert it to numeric.

 

[boblarson]

You can try that, for sure. I haven't ever had a problem with actually referring to it as just =MyCombo.Column(3) and it working properly with the correct currency format. That's why I want to SEE the problem.

 

[pas123]

Thanks, the Val(...) worked.