Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Input Mask Only Numeric and Decimal Point
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01504500
Message ID:
01504502
Views:
51
>Hey everyone,
>
>I have a text field for collecting weight that I need to allow the user to input into. I initially set the input mask for the text box to 99999 and max field length to 5. This works until they have to enter a value of 91.17.
>
>If I max the input mask ##### then they can enter enter blanks (and my users have) which screws up converting that value to a numeric later for processing.
>
>I have to allow for the decimals. Should I use ##### and then do a STRTRAN afterwards and remove any blanks. I'm not sure that this will help ensure the right data was entered since they shouldn't have entered any blanks to begin with. That was why I went with the 99999 format.
>
>Thanks for your thoughts and suggestions.
>
>Kirk

Why not using numeric field for the input with 99999.99 as input mask?
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform