Strange problem with numbers in form

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I have a table with the following numbers. I am using a comma as I am in
Europe

0,100
0,200
0,300
0,400
0,500

In the table the field is set to Number , double and standard with 3 decimal
places. I have tried others.
when I add a combo box and run the sql to test, I get the above numbers.

When I look in the drop down I get the following
0,10
0,20
0,30

in the combo box prop, I have it set to format fixed (have tried the others)
and decimal places 3,

I get 0,000 in the box and when I choose from the list, it remains at 0,000
thanks for any insight
Michael
 
Besides the formatting of the combobox itself, use
FormatNumber([value],3) expression inside the SQL rowsource to format
the list.
 
Thanks, I have tried your suggestion and cannot seem to get that to work
either.

I have tried to create a list instead and the numbers show in the dropdown
correctly

In my list values I have,
0,100;0.200;0.300;0.400;0.500

They show correctly in the list but if I set the value of the combolist to
standard , with decimal 3 I get 300,000
General I get 300
Fixed I get 300,000

to get any numbers to stay I had to use a "." in the values instead of a ","
but in Italy the number should be a comma. If I use a comma, I will see
0,000 after I have made a choice, I have checked to make sure my system is
set for European numbers. On my keypad, where in the US keyboards have
period next to the "0" I have a comma, so it should see the number
correctly.

thank you for your help
 
I just changed to a text box and when I enter any number with a comma first,
I get the same problem, 0,000
if I type in 100 I get 100,000 as I have the decimal set to 3
any ideas?
thanks
Michael

Michael said:
Thanks, I have tried your suggestion and cannot seem to get that to work
either.

I have tried to create a list instead and the numbers show in the dropdown
correctly

In my list values I have,
0,100;0.200;0.300;0.400;0.500

They show correctly in the list but if I set the value of the combolist to
standard , with decimal 3 I get 300,000
General I get 300
Fixed I get 300,000

to get any numbers to stay I had to use a "." in the values instead of a
"," but in Italy the number should be a comma. If I use a comma, I will
see 0,000 after I have made a choice, I have checked to make sure my
system is set for European numbers. On my keypad, where in the US
keyboards have period next to the "0" I have a comma, so it should see the
number correctly.

thank you for your help



a said:
Besides the formatting of the combobox itself, use
FormatNumber([value],3) expression inside the SQL rowsource to format
the list.
Click to expand...
Click to expand...
 
Back
Top