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

[Rod]

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

 

[Ken Snell]

Post the Row Source that you're using for the combo box.

--

Ken Snell
<MS ACCESS MVP>

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: 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

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.

 

[Van T. Dinh]

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)

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: 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

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.

 

[Rod]

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!