Concatenation

[mike]

I am concatenating multiple fields in a pivot table and
need to add a carriage return (like vbcrlf)to get the
field to word wrap.
Any one have an idea???

this is my code:
[partid]&" "&[customer po]&" "&[customer]&" "&[customer]
I would like it to word wrap after the customer po.

 

[M.L. Sco Scofield]

As you have probably already figured out, VBA constants are not recognized in a query. However, VBA functions are! You can use:

....& Chr$(13) & Chr$(10) &...

Good luck.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

 

[MIke]

Thanks! it works great!

-----Original Message-----
As you have probably already figured out, VBA constants

are not recognized in a query. However, VBA functions are!
You can use:

....& Chr$(13) & Chr$(10) &...

Good luck.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

I am concatenating multiple fields in a pivot table and
need to add a carriage return (like vbcrlf)to get the
field to word wrap.
Any one have an idea???

this is my code:
[partid]&" "&[customer po]&" "&[customer]&" "&[customer]
I would like it to word wrap after the customer po.

.

 

[M.L. Sco Scofield]

You're welcome. Happy to have been able to help.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

Thanks! it works great!

-----Original Message-----
As you have probably already figured out, VBA constants

are not recognized in a query. However, VBA functions are!
You can use:

....& Chr$(13) & Chr$(10) &...

Good luck.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

I am concatenating multiple fields in a pivot table and
need to add a carriage return (like vbcrlf)to get the
field to word wrap.
Any one have an idea???

this is my code:
[partid]&" "&[customer po]&" "&[customer]&" "&[customer]
I would like it to word wrap after the customer po.

.

 

[mike]

It worked in the query and a regular form, but did nothing
when I placed it as the row value of a access 2002 pivot
table.
any ideas?

-----Original Message-----
You're welcome. Happy to have been able to help.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

"MIke" <[email protected]> wrote in

message news:[email protected]...

Thanks! it works great!

-----Original Message-----
As you have probably already figured out, VBA

constants
are not recognized in a query. However, VBA functions are!
You can use:

....& Chr$(13) & Chr$(10) &...

Good luck.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

I am concatenating multiple fields in a pivot table and
need to add a carriage return (like vbcrlf)to get the
field to word wrap.
Any one have an idea???

this is my code:
[partid]&" "&[customer po]&" "&[customer]&" "& [customer]
I would like it to word wrap after the customer po.

.

.