>How do I format a 10 char field to (999) 999-9999 in a report? (it also must be blank if no number exists)...is there a simple format, or do I need to use a messy IIF expression? I tried TRANSFORM, but no go...
Never mind, I gave up on Format. This expression isn't all that bad:
iif(empty(phone),'',transform(phone,'@R (999) 999-9999')), and works.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.