>I tried putting R in the format box before the 9-999-999-9999 and all it did was print out the R, and then the rest of it like: R9-999-999- and i also tried it with a space like: R 9-999-999-
>It still is not working. I know the R works for text boxes on forms, but how can I get it to work on my report?
>
The textbox should have a Format property of R and an InputMask of 9-999-999-9999 for input; on output, use:
TRANSFORM(cMyVar, '@R 9-999-999-9999')
Specifying a format in an inputmask requires the use of the @ prefix, and the Format should be separated from the string by a space. Works for me.