How to stack fields on Access report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Access 2003

Area: Reports

With the fileds shown, how do I get [Lastname] immediately under [Firstname]
when [Comments] is a Memo field set to
Grow="yes"?

WHAT I WANT:
[Firstname] [Comments]
[Lastname] xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx



WHAT I GET:
[Firstname] [Comments]
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
[Lastname]

I have entered =[Firstname]&CHR(10)&[Lastname] into the Control Source and
it concatenated them but on the same report line.

The same result occurs if I move the two fields above/below each other in
Reports Design View.

Thanks Dennis
 
Using Access 2003

Area: Reports

With the fileds shown, how do I get [Lastname] immediately under [Firstname]
when [Comments] is a Memo field set to
Grow="yes"?

WHAT I WANT:
[Firstname] [Comments]
[Lastname] xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx

WHAT I GET:
[Firstname] [Comments]
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
[Lastname]

I have entered =[Firstname]&CHR(10)&[Lastname] into the Control Source and
it concatenated them but on the same report line.

The same result occurs if I move the two fields above/below each other in
Reports Design View.

Thanks Dennis
Click to expand...

You were close, but sorry, no cigar!
You need to use chr(13) & chr(10) together ... in that order ... in
Access.
Using a new unbound control, set it's control source to:
= [FirstName] & chr(13) & chr(10) & [Lastname]
Then do not display your existing FirstName and LastName controls, but
keep them in the report's record source.
 
Thanks for your time and knowledge!

Rick B said:
Why not put "Comments" next to "LastName"?

[FirstName]
[LastName] [Comments]

--
Rick B



Dennis said:
Using Access 2003

Area: Reports

With the fileds shown, how do I get [Lastname] immediately under
[Firstname]
when [Comments] is a Memo field set to
Grow="yes"?

WHAT I WANT:
[Firstname] [Comments]
[Lastname] xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx



WHAT I GET:
[Firstname] [Comments]
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
[Lastname]

I have entered =[Firstname]&CHR(10)&[Lastname] into the Control Source and
it concatenated them but on the same report line.

The same result occurs if I move the two fields above/below each other in
Reports Design View.

Thanks Dennis
Click to expand...
Click to expand...
 
Back
Top