Example: I have 1 field on a table that has the phone number using the phone number input mask and another field that has the phone type (ie Home, Work, Cell). I created a new field using string concatenation to combine the two but the input mask does not hold for the phone number. I wanted to do this so I can use the new field on reports to combine phone type and phone number.
Reply from Richard Rost:
Input masks won't work that way. The field has to be uniform. You'll have to use the FORMAT() function when you concatenate two fields together like that. Access Expert 11, Lesson 3. Something like:
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 9.
