Print concatenated formatted text in report

[Richard S.]

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

 

[Al Campagna]

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],"(@@@) @@@-@@@@")

--
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."

 

[Richard S.]

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
will cause problems.
I'll use YourDate as a name.
Try this concatenation...
= [TextField] & " " & Format([YourDate],"(@@@) @@@-@@@@")

--
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
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