Percent decimal places .00%

[Bill R via AccessMonster.com]

I would like to display percentages with the number of decimal places
required to do the job, up to a maximum of 2 decimal places. So that .55
would display as 55%, .055 would display as 5.5%, .0055 would display as .55%
and .00055 would display as .06%. Is there any way to make that happen?

Thanks,

Bill

 

[Ken Snell [MVP]]

Set the format to Percent and Decimal Places to 2.

 

[Bill R via AccessMonster.com]

Would that it were that simple. That's exactly how I have it set now, but .55
displays as 55.00%, .055 displays as 5.50%, .0055 displays correctly as .55%,
and so does .00055 as .06%. The last 2 are fine, it's the extra 0's I object
to when the decimal places aren't needed (55% for the 1st, 5.5% for the 2nd
situation is what I'm looking for).

Set the format to Percent and Decimal Places to 2.

I would like to display percentages with the number of decimal places
required to do the job, up to a maximum of 2 decimal places. So that .55

[quoted text clipped - 5 lines]

Bill

 

[Ken Snell [MVP]]

Ahhhh... I was not understanding this. Set the decimal places to Auto.

--

Ken Snell
<MS ACCESS MVP>

Would that it were that simple. That's exactly how I have it set now, but
.55
displays as 55.00%, .055 displays as 5.50%, .0055 displays correctly as
.55%,
and so does .00055 as .06%. The last 2 are fine, it's the extra 0's I
object
to when the decimal places aren't needed (55% for the 1st, 5.5% for the
2nd
situation is what I'm looking for).

Set the format to Percent and Decimal Places to 2.

I would like to display percentages with the number of decimal places
required to do the job, up to a maximum of 2 decimal places. So that .55

[quoted text clipped - 5 lines]

Bill

 

[Ken Snell [MVP]]

Sorry... ignore my just-sent post about setting the Decimal property to
Auto.

I assume that you're doing this in a form's textbox, and that you do not
need to edit the value that is being displayed. If yes, create a textbox
with the Format property set to "blank", and Decimal property to Auto. Use
an expression similar to this as the Control Source of that textbox:

=Round([FieldOrControlNameWithOriginalValue],4)*100 & "%"


--

Ken Snell
<MS ACCESS MVP>

Would that it were that simple. That's exactly how I have it set now, but
.55
displays as 55.00%, .055 displays as 5.50%, .0055 displays correctly as
.55%,
and so does .00055 as .06%. The last 2 are fine, it's the extra 0's I
object
to when the decimal places aren't needed (55% for the 1st, 5.5% for the
2nd
situation is what I'm looking for).

Set the format to Percent and Decimal Places to 2.

I would like to display percentages with the number of decimal places
required to do the job, up to a maximum of 2 decimal places. So that .55

[quoted text clipped - 5 lines]

Bill