?
Solved

Access 2010 Input Mask for UK Tel No

Posted on 2012-08-30
3
Medium Priority
?
999 Views
Last Modified: 2012-08-30
Hi,

I have a form that I want users to enter a telephone number into in the following format:
+44 (0) 1234 567890

I have tried to no avail using the "Input Mask" option in the form properties sheet.

Can anyone suggest how best to do this, if it is possible of course?

Many thanks
0
Comment
Question by:andrewpiconnect
  • 2
3 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38351828
Input mask? or do you really want a "format" ...or Both?

An Input mask will format the values as you are entering them, ...but once you leave the control, the formatting disappears.
A format does the opposite,...it displays the data as you want, but does not control how it is entered.

In any event, try this if you need an Input mask:

    \+00" ("0") "0000\ 000000""
0
 

Author Comment

by:andrewpiconnect
ID: 38351885
I'm not sure what you mean. The Input Mask you provided works in that it ensures users enter the tel no correctly.

Do you recoomend a different way to achieve this then?
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 38351997
<Do you recoomend a different way to achieve this then? >
Nope,

I just wanted to make sure I gave you exactly what you wanted...

;-)

Jeff
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

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 Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

840 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