Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 [Help] Microsoft ACCESS

views
     
TSGurdian
post Jul 14 2006, 01:34 AM, updated 20y ago

 

******
Senior Member
1,648 posts

Joined: Jan 2003
From: PJ, Malaysia
i need an input mask which does this:

input: 1234567890
display: 12 3456 7890

BUT also does this at the same time:
input: 12345678
display: 1234 5678

In other words, it has to be able to tell that how many digits are there. If there are 10 digits, it will automatically format the digits as shown. If 8 digits, it'll show the latter.

Hope someone can help. Thanks.
transfield
post Jul 14 2006, 02:53 PM

Rich Old Man
*****
Senior Member
946 posts

Joined: Apr 2006
From: Kuala Lumpur


You'll get better help here:-
http://www.mrexcel.com/board2/viewforum.php?f=14
http://www.ozgrid.com/forum/forumdisplay.p...&daysprune=&f=7

Good Luck.

 

Change to:
| Lo-Fi Version
0.0156sec    0.94    5 queries    GZIP Disabled
Time is now: 21st December 2025 - 04:14 PM