Concatenate Phone Number Control

[bill crumpton]

i have a phone number control on a form with the format of (000) 000-0000. However if I create an unbound text field on a report and want to concatenante the phone number field into some text then I loose the format of the field. For example: the phone looks like this in the report...1233331212...no parenthesis or dashes. Any help on keeping the format of a control during concatenating would be very appreciated.

thanks.

BAC

 

[David R]

You'll probably have to include the same format code within your concatenation expression. Phone numbers are stored w/o the formatting codes, if those codes are part of the input mask.

HTH,
David R