Print concatenated formatted text in report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard S. - 31 Jul 2008 16:03 GMT

I am attempting to print a concatenated text field consisting of a text field
followed by a second text field which is a telephone number with an input
mask of
!\(999") "000\-0000;;_ If printed as a separate text field, the phone
number prints with the desired format. However, when concatenated, it prints
as a 10-character text field with no formatting.

The purpose of the concatenation is to manage the variable spacing in the
report field, rather than having 2 fixed-length text areas.

The concatenation is similar to this: descripFld & " " & numberFld.

I will appreciate any help or suggestions.

Riichard

Reply to this Message

Al Campagna - 31 Jul 2008 16:43 GMT

Richard,
Don't name your date field "Date". It's a reserved word in Access, and
will cause problems.
I'll use YourDate as a name.
Try this concatenation...
= [TextField] & " " & Format([YourDate],"(@@@) @@@-@@@@")

Signature

hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

>I am attempting to print a concatenated text field consisting of a text
>field
[quoted text clipped - 13 lines]
>
> Riichard

Reply to this Message

Richard S. - 31 Jul 2008 18:14 GMT

Thank you, Al. That's exactly what I was searching for.

> Richard,
> Don't name your date field "Date". It's a reserved word in Access, and
[quoted text clipped - 20 lines]
> >
> > Riichard

Reply to this Message