Change dot into comma on keypath of keyboard while data entry

[Ton Spies]

Are your users entering numeric data with decimals?
Want a comma as decimal sign?
The keypath of the keyboard produces a dot?
Want to change the the keypath dot into a comma?

Put next line as CanWiteField in the tab Events of the fieldrules.

a_field_value.value= chrtran(a_field_value.value,".",",")

Ton

[petervdm]

Re: Change dot into comma on keypath of keyboard while data entry

Hi,

this works just fine!!! Thanks, this is what i was looking for!
But . . .

Say, i use MySql, where you have to save your number-fields with a "." as decimal-separator?
Do something with "OnSaveRecord"?
And afterwords, when reading from table and presenting to the user, convert it again backwords, so the user sees a ",".

you gatta be kidding me, right?
I see you're from holland, like me, so:
leuker kunnen we het niet maken, wel makkelijker . . .

[Ton Spies]

Re: Change dot into comma on keypath of keyboard while data entry

Hi Peter,

Thanks for your complimenten. I appriciate that geweldig.
It was a big puzzle but finally the solution was simple.
I know the presentation does not give a 100% satisfaction but almost.
Glad you can use it.

Say, i use MySql, where you have to save your number-fields with a "." as decimal-separator?

If you use MySql, and need a dot as decimalsign, then don't take that line of code in the fieldrule.

Do something with "OnSaveRecord"?

Maybe. It depends on what you want to achive. I found this solution with a lot of 'trial and error'.

And afterwords, when reading from table and presenting to the user, convert it again backwords, so the user sees a ",".

This is new / another problem.
Input with a dot and output with a comma als decimal sign?
It depends on what way you are presenting. Printing a report gives you the regional windows setting. So no problem I think.

Put your questions in another section and please come back with usable solutions and tips in this code archive section.

Saluut

Ton

[petervdm]

Re: Change dot into comma on keypath of keyboard while data entry

Hi Peter,

If you use MySql, and need a dot as decimalsign, then don't take that line of code in the fieldrule.

That will do the job, of course, but users are used to see a "," in a numeric field when entering data, and also when browsing in a grid, or form.

Komplemeente,
Peter
(= Maastrichts voor "groetjes")