Field in my table won't take decimals

[Rich_B]

Hi

I am trying to enter a value 103.234 into a table field.

In design view I have:

- Field Size @ Decimal
- Format @ Standard
- Decimal Places @ 3

When I input 103.234 into the field it defaults to 103.000

How can I get it to display 103.234?

Thank you

 

[plog]

In design view of the table, what is the Field Size of that field?

 

[Rich_B]

In design view of the table, what is the Field Size of that field?

It is set to 'Decimal'

 

[plog]

Weird. Can you upload a database with just the relevant objects in it?

 

[Rich_B]

Weird. Can you upload a database with just the relevant objects in it?

How would I do that?

 

[plog]

There's a 'Go Advanced' button next to the Message submission button. Click on that, then in the next page there will be a 'Manage Attachments' button in the Additional Options area. Use that module to uploading and attaching your file.

 

[Rich_B]

Re: (Solved)Field in my table won't take decimals

There's a 'Go Advanced' button next to the Message submission button. Click on that, then in the next page there will be a 'Manage Attachments' button in the Additional Options area. Use that module to uploading and attaching your file.

Fixed it.

I hadn't set the scale to 3.

Thank you for your input.



edited to show Solved in Title
jdraw