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
[Solved] Form from Query - Numeric field entered as Currency Field
[Solved] Form from Query - Numeric field entered as Currency Field
Last edited by Dalke55 on Sun Apr 21, 2024 7:47 pm, edited 1 time in total.
Apache OpenOffice 4.1.6 Windows 10
-
- Volunteer
- Posts: 1551
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: Form from Query - Numeric field entered as Currency Field
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.
<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
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
[Solved] Form from Query - Numeric field entered as Currency Field
Thank you!
Apache OpenOffice 4.1.6 Windows 10