Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / July 2007

Tip: Looking for answers? Try searching our database.

Input Mask is truncating

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Roz - 09 Jul 2007 15:58 GMT
I have the following input mask on my form \1:999999

This will always give the user 1:  and allow them to enter up to 6 numbers
after the colon.  But, if the first number after the colon is 1 for example
1234, it truncates the number one and only displays 234.   So, I type: 1:1234
and it returns 1:234.

Has anyone found a solution for this?  Please help.

Roz
Damon Heron - 09 Jul 2007 16:48 GMT
Not sure how you are using this number, but try "1:"999999 (or \1\:999999)
This will give you 1:and your number.

Damon

>I have the following input mask on my form \1:999999
>
[quoted text clipped - 8 lines]
>
> Roz
Roz - 09 Jul 2007 17:28 GMT
Thanks Damon!  It works like a charm...

Roz

>Not sure how you are using this number, but try "1:"999999 (or \1\:999999)
>This will give you 1:and your number.
[quoted text clipped - 6 lines]
>>
>> Roz
John W. Vinson - 09 Jul 2007 17:25 GMT
>I have the following input mask on my form \1:999999
>
>This will always give the user 1:  and allow them to enter up to 6 numbers
>after the colon.  But, if the first number after the colon is 1 for example
>1234, it truncates the number one and only displays 234.   So, I type: 1:1234
>and it returns 1:234.

Guessing here... but : is a valid input mask character too, so try quoting it:

\1\:999999

            John W. Vinson [MVP]
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.