Input mask & Format question

[Becky]

Greetings

I use the input mask \(999") "999\-9999 in the Phone field of my table.
I wanted the brackets, space and dash stored in the table because the data is
imported into other applications. 1234567890 is stored as (123) 456-7890.

On one of my forms there is a combobox with fields CustID, CustName, Phone.
My problem is how to format the phone number in the cbo. It shows up as
1234567890.

Thanks in advance
Becky

 

[J_Goddard via AccessMonster.com]

Hi -

Set the input mask to \(999") "999\-9999:0 (adding semicolon - zero). This
forces the literals to be stored along with the other characters.

John

 

[Becky]

yes, thanks. I'll use that for all new data.

Hi -

Set the input mask to \(999") "999\-9999:0 (adding semicolon - zero). This
forces the literals to be stored along with the other characters.

John