Combo Box Problem 1

[CarolOB]

I have created a combo box that displays 3 columns:
CartType, #ofowners, and CartFee.
On my form, I have created a field to hold the CartType that is selected from the combo box and a field to hold the CartFee associated with the carttype that is selected in the combo box.
I'm using the expression: =[Forms]![Members]![CartType].[Column](3) as the control source for the CartFee field on the form. This does display the money amount from the 3rd column of my combo box, but if the money amount is $125.00, it only displays it as $125. it supresses the ending zeroes. If the money amount is $125.25, it does display it correctly.
Does anyone know how I can make this display the .00?
Thank you
CarolOB

 

[jebry]

Hi Carol!

Assuming that you are displaying the amount in a text box, just go to the format tab in the properties window for the box and set decimals to 2.

hth
Jeff Bridgham

 

[CosmoKramer]

Or specify the format for the text box to Currency

 

[CarolOB]

I do have the decimal places set to 2 which is one of the reasons that I'm confused. Thanks for the suggestion though. Any other ideas?

 

[CarolOB]

Thanks for the reply. I did have the format set to currency and the decimal places set to 2 in the table. I also set these same values in the text box where I want the money amount to appear, however, when the format is set to currency in the text box, it still only displays the whole dollar amount and it shows it as a regular number (ie it drops the $ sign and the decimal point). example:
$123.00 displays as 123. If I leave the format line blank in the text box and leave the decimal places set to 2 it will display $123.00 as $123. (note the decimal point displays too, but not the 00 cents). CarolOB