How do I loose 2 decimal places in a combo box

[Guest]

I have set up a database for my local Credit union.
I have set the member's id number as an integer in a member table. I have
set the format as "fixed" and decimal places as 0 as an added measure.

I am using a combo box in a form bound to the members id in the members
table. I have also set the format of the box as "fixed" and decimal places
as zero. However, the combo box is displaying the id number with two decimal
places, which I am unable to get rid of. Has anybody also had this problem
and, if so, how was it resolved.
I have designed the data base for use in Access 2000 using Access 2007.

 

[Allen Browne]

If the combo's Row Source has more than one column, chances are that the
displyed data is not what is being stored in the table. If so, you can use
the Format() function in the RowSource to specify how you want the non-bound
column displayed.

Example:
SELECT MemberID, Format([MemberValue], "#,##0") AS DisplayValue
FROM Table1;

 

[Guest]

Hi

It is the "fixed" format that is causing the decimal places.
The sample shown by Access when selecting the fixed format is 3456.79

Remove the fixed format (from the table and combo box) and all should be ok.

hth

Andy Hull

 

[Guest]

Sorry Andy. I tried your method, but it didn't work. Anyway I've used the
fixed format and zero decimal format on other occasions when I used Access
2000 with no problem. The decimal zeros are there when you set up the combo
box using the wizard.

 

[Guest]

I feel I should clarify that the ID Number's in the table doesn't have the 2
decimal places, both with and without the fixed format.

 

[BruceM]

Did you try Allen's suggestion?

Sorry Andy. I tried your method, but it didn't work. Anyway I've used
the
fixed format and zero decimal format on other occasions when I used Access
2000 with no problem. The decimal zeros are there when you set up the
combo
box using the wizard.