Input Mask Not Displaying Correctly...

[BrianExcel]

Hey folks,

I have used the input wizard on my table to format entries in the "Phone" column as a phone number with (###) ###-#### as the format.

Although the wizard seems to work, and the values display correctly in the table, they display as plain text in the userform with that field as the control source.

So although the table shows (123) 456-7890 as the value, the text box field on the userform just shows 1234567890.

Can anyone try and point out what I might be doing wrong?

 

[BrianExcel]

Never mind - I got it. I had to set the input mask on the userform, not just the table.

Thanks!