Usinga a Percentage field in a Combo Box (can't get rid of *.00%)?

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

Guest

I have a Combo Box based on a look up table for a percentage field. The percentage field has been set up as follows

Field Name: Percen
Data Type: Numbe
Field Size: Singl
Format: Percen
Decimal Places:

The values entered into the table are as follows

5
10
20
...
99
100

Everything here works fine. What I am having difficulty with is that when the drop down list appears, the percentage values display as

5.00
10.00
20.00
...
99.00
100.00

This may seem trivial, but is there a way to have the combo box just display the percentage values without the two decimal place? They don't appear in the field after being selected

Any suggestions?
Ro
 
Post the Row Source that you're using for the combo box.

--

Ken Snell
<MS ACCESS MVP>

Rod said:
I have a Combo Box based on a look up table for a percentage field. The
Click to expand...
percentage field has been set up as follows:
Field Name: Percent
Data Type: Number
Field Size: Single
Format: Percent
Decimal Places: 0

The values entered into the table are as follows:

5%
10%
20%
...
99%
100%

Everything here works fine. What I am having difficulty with is that when
Click to expand...
the drop down list appears, the percentage values display as:
5.00%
10.00%
20.00%
...
99.00%
100.00%

This may seem trivial, but is there a way to have the combo box just
Click to expand...
display the percentage values without the two decimal place? They don't
appear in the field after being selected.
 
Use Format() function in the Calculated Field

Format([YourPercentField], "0%")

and use the above in the RowSource rather than your Field.

--
HTH
Van T. Dinh
MVP (Access)




Rod said:
I have a Combo Box based on a look up table for a percentage field. The
Click to expand...
percentage field has been set up as follows:
Field Name: Percent
Data Type: Number
Field Size: Single
Format: Percent
Decimal Places: 0

The values entered into the table are as follows:

5%
10%
20%
...
99%
100%

Everything here works fine. What I am having difficulty with is that when
Click to expand...
the drop down list appears, the percentage values display as:
5.00%
10.00%
20.00%
...
99.00%
100.00%

This may seem trivial, but is there a way to have the combo box just
Click to expand...
display the percentage values without the two decimal place? They don't
appear in the field after being selected.
 
Thanks for your replies

To Ken Snell:

The row source for the combo box was
SELECT [Completion Percentage].[Percentage] FROM [Completion Percentage] ORDER BY [Completion Percentage].[Percentage];

Using Van T. Dinh reply, I changed the row source to
SELECT format([Completion Percentage].[Percentage], "0%") FROM [Completion Percentage] ORDER BY [Completion Percentage].[Percentage];

and it worked perfectly. Now the drop down lists displays the percentages as

5
10
20
...
99
100

I know this sems trivial, but I really appreciate the response

Go Flames Go!
 
Back
Top