Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MS Access Input Mask

Posted on 2011-02-28
10
Medium Priority
?
562 Views
Last Modified: 2012-05-11
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
Comment
Question by:Reyesrj
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
10 Comments
 
LVL 5

Expert Comment

by:kpltechgroup
ID: 35002401
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
 
LVL 5

Expert Comment

by:kpltechgroup
ID: 35002416
##"  "##"  "##

I think would be the exact mask
0
 

Author Comment

by:Reyesrj
ID: 35003082
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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 5

Expert Comment

by:kpltechgroup
ID: 35003115
so you want someone to enter 1234 and have the output be 1..2..3..4?

. = space
0
 

Author Comment

by:Reyesrj
ID: 35003227
kpltechgroup

Yes, it's the double space I'm having trouble with.  This would make data input much faster.
0
 
LVL 5

Expert Comment

by:kpltechgroup
ID: 35003238
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
 
LVL 5

Expert Comment

by:kpltechgroup
ID: 35003582
try input mask
00"  "00"  "00
0
 
LVL 5

Accepted Solution

by:
kpltechgroup earned 1500 total points
ID: 35003601
Oh and try

99CC99CC99CC;0;
0
 

Author Comment

by:Reyesrj
ID: 35052913
Tried it all.  It still requires the user to enter a space.  when a single space is entered it inserts a double space.
0
 

Author Closing Comment

by:Reyesrj
ID: 35079473
Thanks any way.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question