Access '97 Lookup Field - Input Mask Gone

[tallbarb]

I have an employee table with a phone number field. I have another table called leave requests with a phone number field that looks up the phone numbers from the employee table.

In the resulting comb box in the leave requests table, the phone number input mask doesn't display - the numbers all run together (even though the input mask in the employee table is storing the literals).

I've set the mask in both tables the same way and still the phone number shows up without the literals.

However when I build a form for the leave requests table and set the mask on the form control, then choose the phone #, the mask works for the selected phone number.

The thing that bothers me the most is, when clicking into that field in the form to display the combo box with the phone numbers, the combo box shows the unformatted version.

How do I make Access show the phone numbers with the mask characters in the combo box?

 

[OnTheFly]

Have you tried setting the input mask of the combo box control?

Hope this helps.

OnTheFly

 

[tallbarb]

The input mask is set the same way in all three places - in the employee table, in the field properties. In the leave request table, in the field properties. In the form for the leave request in the control properties. The COMBO box display still shows the unformatted phone number.

'Tis a mystery.....and a pain!

 

[OnTheFly]

Very strange. I guess what I would try is to remove the input mask on the phone number on the field in the table, save the table and then open it in datasheet view to make sure it is indeed storing the mask characters. If it is, then I haven't a clue why it is not displaying correctly in the combo box. If it really isn't storing the mask characters then you may want to remove the masks, do a compact and repair of the database and then reenter the mask.

Could be something has gotten corrupted.



Hope this helps.

OnTheFly

 

[tallbarb]

If I apply the @@@-@@-@@@@ format to the field in the training table, the SSN then displays with the dashes after it's selected from the COMBO box. BUT - the COMBO box STILL does not display the dashes. I've tried everything that's been suggested (and thanks so much for your tips) with no success. I give up......