Re: How do I loose 2 decimal places in a combo box

Did you try Allen's suggestion?

"ArkRoyal" <ArkRoyal@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9B8289EA-AA7E-4994-8B12-0756F59F5CEA@xxxxxxxxxxxxxxxx
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.

"Andy Hull" wrote:

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


"ArkRoyal" wrote:

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.



.

Relevant Pages

  • Re: What is wrong with this search for the character PV/PQ
    ... You are compiling fixed format source in which two lines extend beyond ... If you compile it for free format you have old style comments. ...
    (comp.lang.fortran)
  • Re: NASA orbit simulation software
    ... My own experiences in various software systems suggest that while there may be an abstract "fixed format", a dozen different programs will have at least ten different formats. ... Build another dozen and it begins to make sense to enlist a standards organization to start creating standard. ... what's the best launch configuration? ...
    (sci.space.tech)
  • Re: Automatic detection of a COBOL dialect ?
    ... >I must say i have little knowledge about COBOL. ... >For now, I automatically detect fixed or free format, like this: ... > - else it is free format. ... it is fixed format and does not have any number on the 1-6 cols. ...
    (comp.lang.cobol)
  • Re: Infinite Loops and Explicit Exits
    ... The quote that Robert included was for fixed format. ... the period is in column 11 (i.e. the A-margin). ... Standard) doesn't address this question. ...
    (comp.lang.cobol)
  • Re: about c to fortran
    ... printf("%30.20lf %30.20lf\n", DUMMY, PI); ... If you're used to using C, free format will be easier ... So you can edit free format, and compile fixed format. ...
    (comp.lang.fortran)