<div>
Input mask? or do you really want a &quot;format&quot; ...or Both?<br />
<br />
An Input mask will format the values as you are entering them, ...but once you leave the control, the formatting disappears.<br />
A format does the opposite,...it displays the data as you want, but does not control how it is entered.<br />
<br />
In any event, try this if you need an Input mask:<br />
<br />
&nbsp; &nbsp; \+00&quot; (&quot;0&quot;) &quot;0000\ 000000&quot;&quot;
</div>


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""

<div>
I'm not sure what you mean. The Input Mask you provided works in that it ensures users enter the tel no correctly.<br />
<br />
Do you recoomend a different way to achieve this then?
</div>


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?

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a form that I want users to enter a telephone number into in the following format:<br />
+44 (0) 1234 567890<br />
<br />
I have tried to no avail using the &quot;Input Mask&quot; option in the form properties sheet.<br />
<br />
Can anyone suggest how best to do this, if it is possible of course?<br />
<br />
Many thanks
</div>
</div>


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

Access 2010 Input Mask for UK Tel No

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.