Decimals, rounding off

[Jeff]

Hi All,

I have a table field set as Decimal and formatted as Currency and
Decimal Places as 2. I've tried altering these in numerous diffent
combinations!

The problem is that when I input a number, it always rounds off to the
nearest whole number:

Input: 22.55
Result: 23

It just won't show the decimals.

Any help appreciated,

Jeff

 

[Jeff]

Hi All,

I have a table field set as Decimal and formatted as Currency and
Decimal Places as 2. I've tried altering these in numerous diffent
combinations!

The problem is that when I input a number, it always rounds off to the
nearest whole number:

Input: 22.55
Result: 23

It just won't show the decimals.

Any help appreciated,

Jeff

OK, figured it out!

I had the data type as number instead of currency!

So simple!

Jeff

 

[Vincent Johns]

Hi All,

I have a table field set as Decimal and formatted as Currency and
Decimal Places as 2. I've tried altering these in numerous diffent
combinations!

The problem is that when I input a number, it always rounds off to the
nearest whole number:

Input: 22.55
Result: 23

It just won't show the decimals.

Any help appreciated,

Jeff

It's not obvious to me why it should do that, but have you tried setting
up a new Table including a Currency field, to see if it behaves the same
way? If the new one behaves nrmally (and lets you enter the fractions),
as I expect it will, then you can look at the properties of the two
Tables to see what differences there are. Or, you could copy the
contents of the old Table to the new, working one.

If the new Table behaves as the old one did, then perhaps global
settings, such as those in the Regional Settings in Windows Control
Panel, are affecting how currency values are input or displayed; for
example, are you using yen instead of dollars? Since you didn't mention
a currency symbol, I'm suspicious that that could be part of your trouble.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[Jeff]

Thanks Vincent,

As you can see, I got it figured. I spent so long trying different
combinations in the properties. I forgot the data type next to the name
of the field in design view.

Jeff

 

[Vincent Johns]

Thanks Vincent,

As you can see, I got it figured. I spent so long trying different
combinations in the properties. I forgot the data type next to the name
of the field in design view.

Jeff

Well, yes, I saw your 2nd message later, but I had a bit of trouble with
my computer as I was answering and didn't notice it at first.

I'm happy you were able to take care of the problem so quickly.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.