Custom field format

[rwahdan@gmail.com]

Hi, I need to put a field in a form to accept mobile number only in one format which always starts with 05 then followed with 8 numbers. That's the only format allowed.

How can this be achieved?

[Minty]

Have a read here https://support.office.com/en-us/art...4-1fe286636668

You'll want something like \0\500000000 in the form controls format property.

[John_G]

Are the first two characters - 05 - going to be stored in the table with the other 8? If so, you need to use the input mask property, with the second part set to 0, like this:

\0\500000000;0

Read a help article on the input mask property here:

https://msdn.microsoft.com/en-us/VBA...roperty-access