Frequently asked questions - Base

    From The Document Foundation Wiki
    < Faq‎ | Base

    How can I create a field that displays 'phone numbers in my country's standard format?

    • Select a field
    • To make the telephone number appear in the specific format 00 00 00 00 00
      • Click on the three dots which are to the right of the format field
      • In the format window which opens choose the type "Number" and put in one of the following formats for the telephone number:
    00" "00" "00" "00" "00 	00\ 00\ 00\ 00\ 00 	##\ ##\ ##\ ##\ ##
    • Validate this format by clicking the icon then OK
    • Close the table
    • Using the wizard create a form with the telephone field on it
    • In design mode, click on the form navigator to access all the form controls.
    • A right click on the telephone number field will allow you to check and complete the control properties.
    • Exit design mode. The form is now ready to use for entering data.
    • Enter the telephone number without spaces
    • The formatting is applied when the cursor moves to the next field.