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

Did you set the Format property of the ComboBox?

"Sharkbyte" wrote:

> 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

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

Sharkbyte


"KARL DEWEY" wrote:

> Did you set the Format property of the ComboBox?
>
> "Sharkbyte" wrote:
>
> > 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

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

"Sharkbyte" wrote:

> No. I see nothing, in the available formats, that would make sense to set.
> Am I missing something?
>
> Sharkbyte
>
>
> "KARL DEWEY" wrote:
>
> > Did you set the Format property of the ComboBox?
> >
> > "Sharkbyte" wrote:
> >
> > > 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

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

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

Sharkbyte



"KARL DEWEY" wrote:

> Try this on the form input mask --
> !\(999") "000\-0000;;_
>
> "Sharkbyte" wrote:
>
> > No. I see nothing, in the available formats, that would make sense to set.
> > Am I missing something?
> >
> > Sharkbyte
> >
> >
> > "KARL DEWEY" wrote:
> >
> > > Did you set the Format property of the ComboBox?
> > >
> > > "Sharkbyte" wrote:
> > >
> > > > 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

Is the input mask of the combo box set?

"Sharkbyte" wrote:

> The Input Mask was already set to !\(999") "000\-0000;0;_
>
> I changed it to match your suggestion, with no difference.
>
> Sharkbyte
>
>
>
> "KARL DEWEY" wrote:
>
> > Try this on the form input mask --
> > !\(999") "000\-0000;;_
> >
> > "Sharkbyte" wrote:
> >
> > > No. I see nothing, in the available formats, that would make sense to set.
> > > Am I missing something?
> > >
> > > Sharkbyte
> > >
> > >
> > > "KARL DEWEY" wrote:
> > >
> > > > Did you set the Format property of the ComboBox?
> > > >
> > > > "Sharkbyte" wrote:
> > > >
> > > > > 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