Currency Display Problem

[peckitt99]

Hi

I have a combo box that has a list of values and one or the coloums contains prices but when i run the form it just shows the number and not currency. even though in the table i put it in currency.

the next problem is that when i select a value it places it into a text box. again it does not show the currency but i am guessing when the first one is sorted out this one should work

also i would like all the values to be Null when the form starts

can anyone help me out?

Thanks

 

[Premy]

See if setting the combo's format property to Currency, helps

Your controls will only be null if the underlying table field is null (u mean null or 0?). You might consider using unbound controls.

HTH
Premy

 

[boblarson]

Just an FYI - formatting items at the level you are displaying. Formatting at table level will not usually carry forward to other objects as it is for display in the table only.