Textbox Controls in Reports

[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!

 

[John Spencer]

Format([Initial count],"#,###")

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

 

[Guest]

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

Format([Initial count],"#,###")

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

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!