I have a mask that looks like 0\.00\.0000
which is used to force serial numbers to look like
1.20.0034
. The problem I have is that the dots (.
) are not put in the database field. How can I use an input mask and make sure the extra characters are put in the database field? We use Access 2007.
I have tried the input mask 0.00.0000
which does insert the .
characters into the field. However when displayed the forms show ,
because that is the decimal mark in dutch....
,
replaces the.
without the backslash character preceding it.