[Solved] Form from Query - Numeric field entered as Currency Field

Creating tables and queries
Post Reply
Dalke55
Posts: 25
Joined: Sat Jan 19, 2019 11:08 pm

[Solved] Form from Query - Numeric field entered as Currency Field

Post by Dalke55 »

I have created a Form for parameter searching using a query. Selected fields form Query in which three of the fields that are formatted as Number [NUMERIC] length (8) Decimal places (5) format example show's as 0.00000. The issue is that in the Form the fields are showing as Currency Field and of course the value in the field is presented as a Dollar value, rather than a numeric value. Please instruct me as to my error or what may be causing the error.
Other fields formatted as Number are showing properly in the Form.

Forms created by Design View with the same fields present as Formatted Field

Thank You for any assistance you can provide
Apache OpenOffice 4.1.15
Windows 10
Last edited by Dalke55 on Sun Apr 21, 2024 7:47 pm, edited 1 time in total.
Apache OpenOffice 4.1.6 Windows 10
UnklDonald418
Volunteer
Posts: 1550
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Form from Query - Numeric field entered as Currency Field

Post by UnklDonald418 »

Open the Form document in the Edit/Design Mode
<Ctrl>Click on a problematic control then Right Click and select Control to open the Properties dialog
If the dialog shows Properties: Currency Field
Right click again and select Replace with > Numerical Field
On the General tab of the Properties: Numerical Field dialog you can specify the Decimal Accuracy property.

If dialog is Properties: Formatted Field
Select the small button at the far right of the Formatting property to open Number Format dialog.
There select Number from the Category list.
The Format list will likely have a selection with 5 decimal places or select General and you can specify the number of Decimal Places in the Options area of the dialog.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Dalke55
Posts: 25
Joined: Sat Jan 19, 2019 11:08 pm

[Solved] Form from Query - Numeric field entered as Currency Field

Post by Dalke55 »

Thank you!
Apache OpenOffice 4.1.6 Windows 10
Post Reply