dbTalk Databases Forums  

Numeric value insert decimal by numeric keypad

comp.databases.filemaker comp.databases.filemaker


Discuss Numeric value insert decimal by numeric keypad in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Twan
 
Posts: n/a

Default Numeric value insert decimal by numeric keypad - 10-15-2009 , 07:13 AM






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

Reply With Quote
  #2  
Old   
Grip
 
Posts: n/a

Default Re: Numeric value insert decimal by numeric keypad - 10-15-2009 , 12:02 PM






On Oct 15, 6:13*am, "Twan" <no-re... (AT) skb (DOT) 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.

Reply With Quote
  #3  
Old   
Twan
 
Posts: n/a

Default Re: Numeric value insert decimal by numeric keypad - 10-16-2009 , 09:44 AM



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) cybermesa (DOT) com> wrote

On Oct 15, 6:13 am, "Twan" <no-re... (AT) skb (DOT) 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.