autofill input mask help!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I had replied to a previous post and haven't had any new answers. Can anyone
help? Here is the previous post.
It is working now. I changed my data type to "Long Integer" and edited the
public statement to "as Long". However, I need my box numbers to have a 0
in the front. example "083838". The input mask I had made automatically put
the 0 in. Now it no longer does that. Is there anyway to do this and keep
the zero in the front? I greatly appreciate your help.
 
I had replied to a previous post and haven't had any new answers. Can anyone
help? Here is the previous post.
It is working now. I changed my data type to "Long Integer" and edited the
public statement to "as Long". However, I need my box numbers to have a 0
in the front. example "083838". The input mask I had made automatically put
the 0 in. Now it no longer does that. Is there anyway to do this and keep
the zero in the front? I greatly appreciate your help.
Click to expand...

Whenever you have a "number" which is used as identifier - an address,
a box number, a Zip code, a phone "number" - you should use a Text
datatype. A Long Integer is stored as binary bits; the numbers 13,
013, and 0000013 are ALL EXACTLY THE SAME NUMBER, and are stored
identically.

If you want to store leading zeros, and won't be doing arithmatic with
this box number, use Text instead of Long Integer as your datatype
(and String as the VBA variable type).

John W. Vinson[MVP]
 
How would I right the VB Script to use the Text Data type? I tried to
replace the word "integer" with "text" and it didn't work. Any Suggestions?
Thank you
 
How would I right the VB Script to use the Text Data type? I tried to
replace the word "integer" with "text" and it didn't work. Any Suggestions?
Click to expand...

Use String (I think) - if that's not working please post the relevant
section of your code.

John W. Vinson[MVP]
 
Back
Top