Change comma to point in double

[jaryszek]

Hi People,



I have double field:



But i can only write number with comma, i want to have point, like 2.5:



It is possible to change it within Access or this is windows regional settings?

Best,
Jacek

[Minty]

That's controlled by windows regional settings as far as I am aware.

From a google i got this;

Windows 10 is a little different. To change the system delimiter default or as they call it "List Separator" to a comma you have to go to CONTROL PANEL / REGION / , Click on Additional Settings and then click on the drop down for List separator. You can select Comma from that list.

I'm pretty certain you can't adjust this using VBA, but happy to be proved wrong.

[jaryszek]

Aaa , this is not good for me.

Because i my users can have different regional settings.

Best,
Jacek

[CJ_London]

use a text field rather than a number field - or keep the 2 and 5 in separate fields but display as a 2.5 by concatenating with a '.'

[jaryszek]

aa thank you Ajax,
maybe your solution will prevent from erros in future,

Best,
Jacek