Form's display versus table design

[bknight]

I have a that has as a field General number 6 decimal places. When the form that has as its record set that table opens The form displays only 1 decimal when one decimal is input for example 28.9 displays as 28.9, which is fine, but is there a format of sorts to display 28.90? I tried to change the table to Currency 6 decimal, but that did not change the display, so I went back to general number.

[HansV]

Have you tried General Number with 2 decimal places? Or Fixed with 2 decimal places?

[bknight]

No, but I do need six for accurate calculation. On fractional numbers.

[SpeakEasy]

Change the (display) format to #.00

[bknight]

Change the (display) format to #.00

Where to change?

[HansV]

Is it a field in a table? If so, set it in the properties of that field.
Is it a calculated column in a query? If so, set it in the properties of that column.
Is it a control on a form that has a formula as control source? If so set it in the properties of that control.

[bknight]

It is a field and I don't understand where to put #.00 in the properties. The format has a drop down that doesn't allow typing.

[HansV]

Type #.00 in the Format property. You can type custom formats into this property as well as selecting predefined ones from the drop down list.

[bknight]

It would not allow me to type, so I shut down and restarted and entered the format. That being said, the form still displays only 1 decimal, except where more than one exists. Formating the property sheet of the filed to #.00, results in six digits. So in the end I'll stick with the original display.
Thaanks

[bknight]

I do have another question. When the table was designed and saved the form attached to it opened in a different size. I had adjusted the size to display all fields, so I did this again. But is that normal behavior when the source is designed?

[SpeakEasy]

>results in six digitS

Because you still have the Text Box Decimal Places set to 6, which overrides the custom format setting. I forgot to advise that this should be set to Auto

[bknight]

Set to auto, same as original display, nt sure why but that was ok with me see my previous post.

[SpeakEasy]

>but I do need six for accurate calculation

Just FYI, setting the Format and Decimal Places affects the display only. The actual underlying value is not affected.

[bknight]

Oh I knew that, but these wicked fractions give some long decimals, but they are rational numbers.