Formatting a value

[Sandra]

I obtain a value for a field from a combo box using
= GetID.column(1) in the Control Source. The original
value is formatted as Currency, but when it appears in
the field it is numeric and I have tried every place I
know to reformat to Currency with no success. How do I
do this?

TIA,
Sandra

 

[Wayne Morgan]

You say you are getting the value for a field, I assume you are getting the
value for an unbound textbox. I tried what you have said and setting the
Format property of the textbox to Currency does not get the job done. What
did work was changing the control source.

=Format(GetID.Column(1), "Currency")

 

[Michel Walsh]

Hi,

If everything else fails, try to format at the level of the RowSource:


Me.GetID.RowSource=" SELECT Format( fieldName, 'currency'), ....
FROM .. "




Hoping it may help,
Vanderghast, Access MVP

 

[Sandra]

Wayne, thanks a million, it works like a charm!

Merry Christmas,

Sandra