| Computers Forum Index » Computer - Databases - Filemaker » Numeric value insert decimal by numeric keypad... |
|
Page 1 of 1 |
|
| Author |
Message |
| Twan... |
 Posted: Thu Oct 15, 2009 4:13 pm |
|
|
|
Guest
|
Hey folks,
In my Regional Settings (Win XP) my decimal symbol is a comma and my
thousands seperator is a dot.
In FileMaker "Using System Settings" is on and numbers are displayed
correctly.
BUT... when quickly entering a number winthin FileMaker using the
numeric keypad, for example: 1 2 3 4 [dot] 5 6
FileMaker does not recognize the inserted dot is meant as a decimal
seperator and converts the number to: 12.345,00
Is there a way to fix this problem easily?
Twan |
|
|
| Back to top |
|
|
|
| Grip... |
| Posted: Thu Oct 15, 2009 5:02 pm |
|
|
|
Guest
|
On Oct 15, 6:13 am, "Twan" <no-re... at (no spam) skb.nl> wrote:
Quote: Hey folks,
In my Regional Settings (Win XP) my decimal symbol is a comma and my
thousands seperator is a dot.
In FileMaker "Using System Settings" is on and numbers are displayed
correctly.
BUT... when quickly entering a number winthin FileMaker using the
numeric keypad, for example: 1 2 3 4 [dot] 5 6
FileMaker does not recognize the inserted dot is meant as a decimal
seperator and converts the number to: 12.345,00
Is there a way to fix this problem easily?
Twan
How is this a problem? It is how you've instructed your system to
handle decimal points. You could try remapping your keyboard. Or
having a different field for data entry than from display. But you're
asking Filemaker to interpreter the decimal in two different ways. |
|
|
| Back to top |
|
|
|
| Twan... |
| Posted: Fri Oct 16, 2009 6:44 pm |
|
|
|
Guest
|
Hey Grip,
Thanx for your comment. I resuggested the Help file about the topic "Use
System Settings" and according to that, FileMaker handels strict, but
correctly. Sorry for that.
When the setting is OFF, the input 123.45 is interpreted correctly.
However I remapped my decimal-key on my numeric keypad to a comma using
KeyTweak so problem is solved.
Twan
"Grip" <grip at (no spam) cybermesa.com> wrote in message
news:3711b219-0200-40cb-8621-156a056b6e50 at (no spam) u16g2000pru.googlegroups.com...
On Oct 15, 6:13 am, "Twan" <no-re... at (no spam) skb.nl> wrote:
Quote: Hey folks,
In my Regional Settings (Win XP) my decimal symbol is a comma and my
thousands seperator is a dot.
In FileMaker "Using System Settings" is on and numbers are displayed
correctly.
BUT... when quickly entering a number winthin FileMaker using the
numeric keypad, for example: 1 2 3 4 [dot] 5 6
FileMaker does not recognize the inserted dot is meant as a decimal
seperator and converts the number to: 12.345,00
Is there a way to fix this problem easily?
Twan
How is this a problem? It is how you've instructed your system to
handle decimal points. You could try remapping your keyboard. Or
having a different field for data entry than from display. But you're
asking Filemaker to interpreter the decimal in two different ways. |
|
|
| Back to top |
|
|
|
|
