Textbox Controls in Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to figure out how to format my textbox in my report for the
following settings:

1) Percentage without decimal places
Currently I have the control source pulling in
= "Less"& format([% disc], "Percent")& "Broker Discount"
I want it to read "Less 10% Broker Discount", but it is reading "Less 10.00%
Broker Discount"

2) Number with comma but without decimal places
Currently I have the control source pulling in
= "Base " & format([initial count], "Standard")
I want it to read "Base 10,000" but it is reading "Base 10,000.00"

Thanks!
 
Thanks for your help! I knew it was something pretty simple, I just couldn't
quite figure it out.


John Spencer said:
Format([Initial count],"#,###")

Format([% Discount],"0%")


Mjohnson said:
I am trying to figure out how to format my textbox in my report for the
following settings:

1) Percentage without decimal places
Currently I have the control source pulling in
= "Less"& format([% disc], "Percent")& "Broker Discount"
I want it to read "Less 10% Broker Discount", but it is reading "Less
10.00%
Broker Discount"

2) Number with comma but without decimal places
Currently I have the control source pulling in
= "Base " & format([initial count], "Standard")
I want it to read "Base 10,000" but it is reading "Base 10,000.00"

Thanks!
Click to expand...
Click to expand...
 
Back
Top