text field I am trying to display as currency 2

[piovesan]

Hi all;

I have a text field that is 38 long and I want to display this as a currency....or at least remove all but 2 characters after the decimal. Currently I am seeing data in that field displayed like 20.000000000 etc...... can I do this??
Thanks!
P

 

[PWise]

TRY
format(fieldname,"$000.00")

 

[dhookom]

I would convert the text to a numeric value first:

  Format(Val(textfield),"$000.00")

Duane
Hook'D on Access
MS Access MVP

 

[piovesan]

Where do I enter this? In the format properties within the report?

 

[dhookom]

If you want to do this in a text box, I would set the control source to:
=Val(textfield)
And then set the Format and Decimal properties as necessary.

Make sure the name of the text box is not the name of the field.

Duane
Hook'D on Access
MS Access MVP

 

[piovesan]

OK......... this one seems to be working somewhat...
=Val(textfield)

I have set this in the textbox so that I have types the name to be "Acqusition Cost" and the Control Source is =Val([ACQ_COST]) (which is the name of the field.
I have also set the format to "currency"

I have two problems with this:
1. If the ACQ_COST field is null or blank, I see a #Error on the report. (I would prefer just to have it blank or have it say "no cost"

2. Because I have types in the name of the textbox to be "Acqusition Cost", when I run the report, I get a request to "enter parameter value" for that (I assume it's because there is no field named that in the table?)

Is there a way to fix these two issues?
Thanks!
P

 

[piovesan]

oops.....I fiqured out the #2 parameter values message I was getting! Was another field where I summed them up that was the problem.........
P

 

[dhookom]

To avoid issues with Null, try:

=Val(Nz(textfield,0))

You can set the format property to display "no cost" if the value of the text box is 0.

Duane
Hook'D on Access
MS Access MVP