Export Query to a csv file keeping formatting for telephone No (1 Viewer)

[Number11]

Is there a way to have access export a query keeping the prefix "0" of the telephone numbers

 

[Number11]

have this setup but still exports without the 0

FormattedTel1: Format([Phone1],"00000000000")

 

[Number11]

ok yes the above does work now if i open in notepad

how do i remove the spaces in a telephone numberlike

0000 000 00000

 

[Gasman]

Use Replace() function.

 

[Pat Hartman]

If you do this right from the beginning, you can set up the format to NOT save the formatting characters. It helps people with data entry to have the formatting characters but you never want them to be saved.

Fix the input mask property and then do a one time update to get rid of all the formatting characters.

Also, I know phone numbers look like they are numeric but technically they are a code and codes are strings. Strings will retain leading zeros but numbers will not.