I have a field which stores a UK landline phone number. The vast majority of these numbers are on London exchanges and have the format 020 9999 9999, where 9 is any digit, but a few are outside London and have the format 01999 999999.
I'm using the mask 999 9999 9999 so that the gaps are automatically placed in the right places for London numbers. Because I have Format string on blank field set to Yes, the shorter non-London numbers are accepted, but the space is put in the wrong place.
Could I use Mask definitions to overcome this? If so, how, I don't really understand the instructions!
Grateful for any advice.
I'm using the mask 999 9999 9999 so that the gaps are automatically placed in the right places for London numbers. Because I have Format string on blank field set to Yes, the shorter non-London numbers are accepted, but the space is put in the wrong place.
Could I use Mask definitions to overcome this? If so, how, I don't really understand the instructions!
Grateful for any advice.