A
Associates
Hi,
I have a question that i need your help with Access database. Is there a way
of limiting the decimal point to 2 when a user enters digits for number? I
believe we can use the decimal type with scale of 2. The problem with this is
it doesn't notify user of the fact that it only accepts up to 2 decimal
points. What it does is if i enter something like 234.567, it only accepts
234.56 without telling me that it's going to chop off anything beyond 2
decimal points.
I wonder if we could let them know that this only accepts 2 decimal points.
So when they enter 234.567 - they will be prompted with a message saying "it
only accepts up to 2 decimal points".
I tried to use input mask from the table level but got the error saying it
only applies to text, not number.
Thank you in advance
I have a question that i need your help with Access database. Is there a way
of limiting the decimal point to 2 when a user enters digits for number? I
believe we can use the decimal type with scale of 2. The problem with this is
it doesn't notify user of the fact that it only accepts up to 2 decimal
points. What it does is if i enter something like 234.567, it only accepts
234.56 without telling me that it's going to chop off anything beyond 2
decimal points.
I wonder if we could let them know that this only accepts 2 decimal points.
So when they enter 234.567 - they will be prompted with a message saying "it
only accepts up to 2 decimal points".
I tried to use input mask from the table level but got the error saying it
only applies to text, not number.
Thank you in advance