Text Box Format

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

I have a report with a textbox that is not bound to the underlying query. I
am returning information from a form in this particular textbox. I have
input the following in the textbox:
=Format([Forms]![frmSALES_TOTALS]![TEXT228],"Percent")

My question is this: Can I use edit this equation to return no decimals.
Instead of 20.34%, can I get this equation to return 20%?

Thanks.
 
Don said:
I have a report with a textbox that is not bound to the underlying query. I
am returning information from a form in this particular textbox. I have
input the following in the textbox:
=Format([Forms]![frmSALES_TOTALS]![TEXT228],"Percent")

My question is this: Can I use edit this equation to return no decimals.
Instead of 20.34%, can I get this equation to return 20%?
Click to expand...


Sure, just use the specific format that you want. e.g.

=Format([Forms]![frmSALES_TOTALS]![TEXT228],"0%")
 
Back
Top