How to measure the length of Currency field

[Guest]

I have a currency field and would like to obtain the number of charactors in
this currency field for a text control in the report. For example, if the
value of this currency is $546,789.24, I would like to have 11 as the number
of charactors to be used in the control's calculations. If the value of the
currency is $35.68, I would like to have 6 to be used in the control's
calculations. Would anyone please let me know I should handle this? Thanks!!

 

[Joseph Meehan]

I have a currency field and would like to obtain the number of
charactors in this currency field for a text control in the report.
For example, if the value of this currency is $546,789.24, I would
like to have 11 as the number of charactors to be used in the
control's calculations. If the value of the currency is $35.68, I
would like to have 6 to be used in the control's calculations. Would
anyone please let me know I should handle this? Thanks!!

I am going to guess you want to insert this filed into some text and
your don't want something like:

The amount spent was $546,789.24 by the ...

and

The amount spent was $35.68 by the ...

If I am right, I suggest you may want to use Word to print your results.
It can be a lot prettier.

 

[Douglas J. Steele]

I already answered this question for you more than half an hour before you
reposted it. Is there something you didn't understand in that solution?

 

[Guest]

Try and use the Len Function
Len(FieldName)
Should return the length of the field