Combo Box using a Percentage Field

[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?
Rod

 

[hcj]

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.

 

[hcj]

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

Keep on keepin' on!

 

[Guest]

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

Ro

Go Flames Go!!!