B
bh
I have a phone number field, in a table, defined as text which I need as a
combobox lookup on a form for another table.
If I store the data with a format of "(999) 999-9999" then the combobox will
work, provided that I don't use the input mask and the user types each
character, including the brackets; however, if I store the data as
"999-999-9999", and the user tries to type the data in, the autoexpand
feature does not work. If, for example, they type the number "3", then the
first phone number beginning with the number "3" will be displayed, in its
entirety, in the field, and the cursor will jump to the end of the row.
Ideally, I would like to have an input mask (either "(999) 999-9999" or
"999-999-9999"), and the user just enter the numeric digits, and have
autoexpand work to find the correct phone number & populate the field.
Is there a way to do this? Thanks in advance for any help you can offer.
bh
combobox lookup on a form for another table.
If I store the data with a format of "(999) 999-9999" then the combobox will
work, provided that I don't use the input mask and the user types each
character, including the brackets; however, if I store the data as
"999-999-9999", and the user tries to type the data in, the autoexpand
feature does not work. If, for example, they type the number "3", then the
first phone number beginning with the number "3" will be displayed, in its
entirety, in the field, and the cursor will jump to the end of the row.
Ideally, I would like to have an input mask (either "(999) 999-9999" or
"999-999-9999"), and the user just enter the numeric digits, and have
autoexpand work to find the correct phone number & populate the field.
Is there a way to do this? Thanks in advance for any help you can offer.
bh