Formatting a value

  • Thread starter Thread starter Sandra
  • Start date Start date
S

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
 
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")
 
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
 
Back
Top