Combo Box using a Percentage Field

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.

Any suggestions??
Rod

Hi Rod,
There may be a better way, but this works.
1. Rather than selecting from a table, select from a query
that draws from the table.
2. In the query design grid, bring up field properties
for the percent field.
3. Under format, instead of selecting Percent, type
in "0%" (without the quotes).
4. Use this query as your combo box source.

Hope this works for you.

-----Original Message-----
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.

Any suggestions??
Rod
.

Rod,
I knew there was a better way! Apply the "0%" format
to the percent field in table itself.

Keep on keepin' on!

-----Original Message-----
Hi Rod,
There may be a better way, but this works.
1. Rather than selecting from a table, select from a
query
that draws from the table.
2. In the query design grid, bring up field properties
for the percent field.
3. Under format, instead of selecting Percent, type
in "0%" (without the quotes).
4. Use this query as your combo box source.

Hope this works for you.

-----Original Message-----
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.

Any suggestions??
Rod
.

.

hcj,

Thanks for the reply,

That worked even easier than the format([percent],"0%") in the row source for the combo box.

I appreciate the assistance.

Rod

Go Flames Go!!!