Question how to convert . to comma in decimal number?

[collinm]

hi

some user use comma for decimal number and some other use dot

i know ms-access use regional setting

when i record value in the database and the decimal use comma is there a way to convert it to use dot?

 

[Mr. B]

I would suggest that you use an input mask on the field. with that users will not need to provide the dot or anything.

 

[ajetrumpet]

you could always use the replace() function too, if it fits your needs.