Form's display versus table design
-
- BronzeLounger
- Posts: 1412
- Joined: 08 Jul 2016, 18:53
Form's display versus table design
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.
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Form's display versus table design
Have you tried General Number with 2 decimal places? Or Fixed with 2 decimal places?
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1412
- Joined: 08 Jul 2016, 18:53
Re: Form's display versus table design
No, but I do need six for accurate calculation. On fractional numbers.
-
- 4StarLounger
- Posts: 564
- Joined: 27 Jun 2021, 10:46
Re: Form's display versus table design
Change the (display) format to #.00
-
- BronzeLounger
- Posts: 1412
- Joined: 08 Jul 2016, 18:53
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Form's display versus table design
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.
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.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1412
- Joined: 08 Jul 2016, 18:53
Re: Form's display versus table design
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.
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Form's display versus table design
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.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1412
- Joined: 08 Jul 2016, 18:53
Re: Form's display versus table design
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
Thaanks
You do not have the required permissions to view the files attached to this post.
-
- BronzeLounger
- Posts: 1412
- Joined: 08 Jul 2016, 18:53
Re: Form's display versus table design
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?
-
- 4StarLounger
- Posts: 564
- Joined: 27 Jun 2021, 10:46
Re: Form's display versus table design
>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
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
-
- BronzeLounger
- Posts: 1412
- Joined: 08 Jul 2016, 18:53
Re: Form's display versus table design
Set to auto, same as original display, nt sure why but that was ok with me see my previous post.
-
- 4StarLounger
- Posts: 564
- Joined: 27 Jun 2021, 10:46
Re: Form's display versus table design
>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.
Just FYI, setting the Format and Decimal Places affects the display only. The actual underlying value is not affected.
-
- BronzeLounger
- Posts: 1412
- Joined: 08 Jul 2016, 18:53
Re: Form's display versus table design
Oh I knew that, but these wicked fractions give some long decimals, but they are rational numbers.