Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 574
  • Last Modified:

MS Access Input Mask

In MS Access for the input mask:
How do you insert a double space where the user only enters numbers or letters and not have to manually enter a double space.

EX:
02  28  2011

I created a form and inserted a picture (jpg) of a document that needs to be filled-out.  The document has boxes so I need to space the numbers or letters to fit in the box.  I know how to enter single spaces but not double.  In the example above when it comes to double spaces the user is forced to hit the space bar twice.  For single spacing, the spaces are entered automatically by Access so it’s continues typing.

Any help would be appreciated.
0
Reyesrj
Asked:
Reyesrj
  • 6
  • 4
1 Solution
 
kpltechgroupCommented:
2 spaces your could do either:

"(PressSpaceBarTwice)"

or

\(PressSpacebar}\(PressSpacebar)

Both of these would perform the same results
C\ C\ \ C\ \ C

or

C" "C" "C" "C

For more info see here http://bytes.com/topic/access/answers/202491-help-input-mask-spce
0
 
kpltechgroupCommented:
##"  "##"  "##

I think would be the exact mask
0
 
ReyesrjAuthor Commented:
If I enter "0\ 0\ 0\ 0" into the input mask this is what happens:

I type: "1234"
I get: "1 2 3 4"

No need to type the spaces.

The examples you gave makes it mandatory to type a space.  No other characters can be entered.  In my example Access enters the space for you after each character. So I type only "1234" (without typing a space) and the results are "1 2 3 4".  How would you apply this to a double space?  Entering two spaces after the \ or between two quotes I get:

I type: "1 2 3 4"
I get: "1  2  3  4"
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
kpltechgroupCommented:
so you want someone to enter 1234 and have the output be 1..2..3..4?

. = space
0
 
ReyesrjAuthor Commented:
kpltechgroup

Yes, it's the double space I'm having trouble with.  This would make data input much faster.
0
 
kpltechgroupCommented:
I dont have Access here at work

so you can use "  " in the input mask you have to enclose the double space in  quotes
0
 
kpltechgroupCommented:
try input mask
00"  "00"  "00
0
 
kpltechgroupCommented:
Oh and try

99CC99CC99CC;0;
0
 
ReyesrjAuthor Commented:
Tried it all.  It still requires the user to enter a space.  when a single space is entered it inserts a double space.
0
 
ReyesrjAuthor Commented:
Thanks any way.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now