input mask for currency

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

Hello

Does anybody know how to set up an input mask for currency
so that you can only input two figure after the decimal
place.

Thanks in advance

Martin.
 
Hi Martin,

try to set the input mask property of the textbox with this:

9999999999999999999999999999.00

The 9's represent number before decimal and 00 will force user to type 2 figures after decimal. Make sure you put enough 9's to cover your possible max value.

Hope this helps.

----- Martin wrote: -----


Hello

Does anybody know how to set up an input mask for currency
so that you can only input two figure after the decimal
place.

Thanks in advance

Martin.
 
Have you tried just setting the Format property on the control to Currency
with the Decimal Places property set to Auto? This does allow the user to
enter more than two digits after the decimal, but then rounds it off. Or is
that what you're trying to prevent?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Input Mask Help 1
Creating Custom MS-Access Input Masks 0
Date Input Mask Question 4
value of a field with an input mask? 10
Input Mask - quick question 6
Telephone number Input mask displaying in form control 2
Date format -medium date input mask-French Canadian 5
Storing Values Created from an Input Mask 1

Back
Top