Formatting for 3 decimal places

[Triland]

I am working with a report, using numbers. I would like to have the number display out only three dicamal places. I have changed the format to Fixed and Decimal to three and it is not working. Any ideas on what else I might need to change?

[alansidman]

How is the data formatted in the underlying table?

[June7]

What do you mean by 'not working'? What happens? What is the data type of the field?

[Triland]

The data in the underlying table is fomatted as Fixed and Decimals set to 3. So on the form (when the item is selected in the dropdown menu) I simply want the number to dispaly out 3 decimal places. Ex: 1123 would be 1.123

[June7]

What is the data type of the field? The formatting in the table is irrelevant. The formatting in the control should supersede.

Setting field to Fixed 3 decimals would cause 1123 to display as 1123.000 if the data type is Number.

[Triland]

the data type of the field in Number.

[Triland]

You are correct about the 1123 and 1123.000 piece as well. I noticed that in the sytem with different data.

[June7]

Well, I just did a test with field set a Number Long Integer and the Fixed 3 decimal formatting worked. 1123 is displayed as 1123.000. However, because this field is set as Long Integer, cannot enter data like 1123.742. Same for Integer FieldSize.

Guess don't really understand your issue.

[Triland]

I'm gonna' follow your directions and shoot it over to you ... one sec

One another note: How do I mark an issue resolved in the forum?

[Triland]

Ok attached is the database. Open the Conduit Fill Calc Circuit Form. Go to circuit dropdown and look at the first one "C005" that is how it should look ... just as an example ... and it only looks like that becuase it just happens to fit. Then look at E0050-1 and that is how it looks when we pull up one of the options in the list. When you look at the total area at the bottom the value comes in great. Not sure what I'm doing wrong.

[June7]

Problem with numbers in combobox RowSource is that they are really text. So the display in unbound Area textbox is text. Convert the data back to number with Val().

=IIf([Cable 1].[Column](1) Is Null,0,Val([Cable 1].[Column](1)))


Mark thread Resolved from the Thread Tools dropdown above first post.

[Triland]

Ok ... last question on this one. Where in the actual form, query or report do you add the coding.

[Triland]

Got it and it worked!!! I will update it ... issue resolved.