Combo Box Data Display

[Guest]

I am having difficulty in displaying a field, within a combo box list,
correctly. The field is a phone number, and was originally saved without
characters, and the return data displays without them.

However, I have rebuilt the table, setting the Input Mask; as well as
setting the Input Mask in the query, providing the results, and on the form,
and the data still returns with no parens, etc.

Any suggestions on how to make the results appear correctly, with parens and
hyphens?

Thanks, in advance.

Sharkbyte

 

[Guest]

Did you set the Format property of the ComboBox?

 

[Guest]

No. I see nothing, in the available formats, that would make sense to set.
Am I missing something?

Sharkbyte

 

[Guest]

Try this on the form input mask --
!\(999") "000\-0000;;_

 

[Guest]

The Input Mask was already set to !\(999") "000\-0000;0;_

I changed it to match your suggestion, with no difference.

Sharkbyte

 

[Guest]

Is the input mask of the combo box set?

The Input Mask was already set to !\(999") "000\-0000;0;_

I changed it to match your suggestion, with no difference.

Sharkbyte