Combo Box List Displays integers with 2 decimals

[DMac]

The source for my combo box is a table with a primary key as a number / byte
with format fixed 0.

The drop down list displays the key values with 2 places of decimal,
regardless of what I do. (e.g. values 1, 3, 6, 9, and 12 display, in the drop
down list, as 1.00, 3.00, ...

The selected value displays properly in the control following selection.

What can be done to force the integer values to be displayed as intgers in
the drop-down list?

This has been a problem since Access 97, and still appears to be an issue in
Access 2003.

Thank you in advance for your comments and suggestions.

 

[NetworkTrade]

a slight sanity check on your verbage......
when you say " The source for my combo box is a table with a primary key as
a number / byte with format fixed 0."....

here's a rhetorical question for you to review:
do you mean that the source for your combo box is a "field" (from a table)
and that field is the primary key of the table?.......and in the design view
of this table - is this field showing itself to be a "Number"? ....and if so
then what is the "Decimal Places" parameter set to?

possibly reviewing those questions will lead you to the fix......

 

[DMac]

I aologize if the language of my original inquiry did not pass your sanity
test.
Please let me clarify a few items.

1. I have over 42 years of active computer development experience.
I have used Access 2.0 through Accress 2003 for about 12 years,
and have tried many independent tests to understand and correct
the problem documented herein. I may have missed something obvious,
but the issue has puzzled me for some time. My ego is suffiiciently in
check
that I am not too proud to ask others for their input. You can teach an
old dog new tricks.

2. The problem result can be replicated by doing the following steps:
a) Start a new blank database
b) Create a table in design view with 2 fields:
field 1: Name: NoMonths
DataType: Number
Properties: Field Size: Byte / Format: Fixed / Decimal Places: 0
field 2: Name: PeriodDesc
DataType: Text
Properties: defaults
c) Make field 1 the primary key
d) Save the table with the name: "Report Periods"
e) Insert 3 records with the values:
NoMonths PeriodDesc
1 "Month"
3 "Quarter"
12 " Annual"
NOTE: The foregoing table will serve as a row source for a combo box in the
following second table.
f) Create a new second table in design view.
g) Use the Lookup date type to create a single field based on the
table "ReportPeriods":
- Select both fields (NoMonths and PeriodDesc)
- Unhide the key field (NoMonths)
NOTE that the values for NoMonths are displaying with 2 decimal places
- Save the table w/o a primary key as "Table 2"
Problem: In Table 2, whenever the combo box is selected to select a value is
a record for the field NoMonths:
1. The results displays correctly as Fixed - 0
2. The values for NoMonths in the drop-down list display as
Fixed - 2

What am I doing wrong, or how do I correct the drop-down list display ?

Thank you for your time and wisdom in this matter.

 

[NetworkTrade]

I can only contribute to your frustration by telling you that I duplicated
your process that you described - thinking that you had discovered a bug in a
table-lookup feature: and mine works fine !!! no two decimal places showing
at all...

Am working in Access 2002 w/ 2000 file type....

sorry ........maybe consider test on another machine.....or I would be happy
to email you this mdb and see if once started without this problem perhaps it
will continue without this problem on your machine.....

 

[DMac]

Thank you for your effort.

We both know that computers are generally predictable hunks of machinery,
and there is a reason.

My email is: (e-mail address removed)

If you would zip and send your test to me, I will return the favour by
return email.

The issue must be environmental.

I run Access 97, 2000, 2002 and 2003 on my WinXPPro PC.
I get the same results in all 4 versions.

I used my remote Access to several client sites and get the same results.
I am not suggesting that you are hallucenating.
It would be useful to try each other's files on our computers.

I look forward to your email (My Outlook blocks .mbd's, so hence my
suggestion to zip it).

Thank you ... Don MacRae, Calgary, Alberta, Canada