Access 2010 Input Mask for UK Tel No

Posted on 2012-08-30
Last Modified: 2012-08-30

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
Question by:andrewpiconnect
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    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, 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""

    Author Comment

    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?
    LVL 74

    Accepted Solution

    <Do you recoomend a different way to achieve this then? >

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



    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now