data format in a combo box

[leaf]

Hello,

I created a search combo box that will look up records by
phone. However, the format of the phone did not carry
over when phone numbers show up in the drop down search
combox box.

How do I format the phone to be (919)544-0661?

Thanks,

Yeying

 

[John Vinson]

How do I format the phone to be (919)544-0661?

Set the Format property of the combo box to

(@@@)@@@-@@@@

 

[Van T. Dinh]

You are probably using InputMask on the Table Field and/or
TextBox Control on the Form. In this case use the second
argument of the InputMask Property to specify the masking
characters as part of the Field value. Then you don't
have to worry about formatting.

Alternatively, you can use a Calculated Column in your
RowSource Query and use the Format function to format the
tel. number the way you want. For example:

?Format("9195440661", "(@@@)@@@-@@@@")
(919)544-0661

HTH
Van T. Dinh
MVP (Access)