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....