formatting a text box .. from currency to text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

margaret - 10 Nov 2006 21:51 GMT

I am working with Windows XP ... Access 2003. I have a report and I need the
text box to be formatted with text instead of dollars that the box is
formatted in my query. For instance, in my query the dollar amount is
$170.00 ... I need the text box on the report to read 17000 ... how can I go
about doing that?

Reply to this Message

Al Campagna - 10 Nov 2006 22:37 GMT

Margaret,
Just format the field on the report as...
Format = #,###
Decimal places = 0

Signature

hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

(I assume all your values don't involve cents/decimals)

>I am working with Windows XP ... Access 2003. I have a report and I need the
> text box to be formatted with text instead of dollars that the box is
> formatted in my query. For instance, in my query the dollar amount is
> $170.00 ... I need the text box on the report to read 17000 ... how can I go
> about doing that?

Reply to this Message

margaret - 12 Nov 2006 17:38 GMT

That doesn't work. Because while I don't want the decimal point, I do need
the decimal places

EX:

$1,700.00 - 170000
$1750.18 = 175018
$1750.20 - 175020

So I guess how the question should have read, is how do I eliminate the
decimal point, but keep the decimal places.

> Margaret,
> Just format the field on the report as...
[quoted text clipped - 6 lines]
> > $170.00 ... I need the text box on the report to read 17000 ... how can I go
> > about doing that?

Reply to this Message

John Spencer - 12 Nov 2006 19:10 GMT

Multiply the field by 100 and set the format to #,##0

OR

Multiply by 100 and use the INT function to truncate any trailing (decimal values)

Int(170.01 * 100)

If you have numbers that have decimal values that extend beyond two places, then
you may have to look at this solution and extend it.

> I am working with Windows XP ... Access 2003. I have a report and I need the
> text box to be formatted with text instead of dollars that the box is
> formatted in my query. For instance, in my query the dollar amount is
> $170.00 ... I need the text box on the report to read 17000 ... how can I go
> about doing that?

Reply to this Message