Solved Display Less Decimal Point Accuracy To What Is Stored In Calculated Field Of Query

[dalski]

I have deduced that I need to work to 12 decimal places on a double data-type on a calculated field in a query. I have rounded to 12 dp's in the calculated field within the query for the stored value. In the consecutive form I have set the properties of the control to 4 dp & Format as 'General Number', hoping this would coerce the displayed value (not stored value) to my displayed value of 4 dp - no joy.

How does one coerce the displayed value (not stored value) to a lesser decimal point of accuracy on a form control to what is stored in the calculated field of a query or table?

 

[theDBguy]

Have you tried using the Format property? Just a thought...

 

[MajP]

Using the format property you can roll your own, not just the defined constants.
Format([num],"0.0000")
Look at user defined numeric constants

Format function (Visual Basic for Applications)

Office VBA reference topic

learn.microsoft.com

 

[arnelgp]

add the formatting, but not as Expression.
add the format to the query designer.

 

[dalski]

Thank you all @arnelgp I recon that's what I'm after. Interestingly the first few times i tried it I was unable to change this way then all of a sudden after several attempts it allowed this change.

Format Function - I'm probably missing something here, but just testing the format function (thanks as was not aware of it's existence), it affects the stored value of a calculated field. So it would not be useful for further calculations. Absolutely no doubt I'm missing something obvious here & embarrassing myself. The custom formats are so cool on it.

Thank you all again - most grateful.

 

[Pat Hartman]

it affects the stored value of a calculated field.

Depends where you use it. If you use it in the calculation, then it affects what gets stored. If you use it to display a value, it does not change what gets stored.

 

[dalski]

Depends where you use it. If you use it in the calculation, then it affects what gets stored. If you use it to display a value, it does not change what gets stored.

Thanks Pat, sure enough I missed something .