One text box with Lname on second line

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SusieQ - 01 Jan 2007 07:37 GMT

Hi,

I would like to force the last name to appear on the second line. Two text
boxes, lname below fname, doesn't work because I have subreports on the same
line which causes the lname to appear below the subreports.

Is there anything wrong with the following code:
=Trim([FName] & Chr(13) & Chr(10) & [LName])

Thanks in advance,
Susie

Reply to this Message

Jeff Boyce - 01 Jan 2007 12:48 GMT

I would use two text controls in a report. What is it about the placement
of your subreports that is causing the [lname] control to appear below them?

I didn't notice anything wrong with the expression ... what happens when you
use it?

Signature

Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

> Hi,
>
[quoted text clipped - 7 lines]
> Thanks in advance,
> Susie

Reply to this Message

SusieQ - 02 Jan 2007 04:26 GMT

Thanks, Jeff,
Resolution was the Can Grow property needed to be set to Yes. The two text
boxes didn't work because I had the fname/lname in col. 1, subreport in
col.2, textbox in col 3, 4 & 5, subreport in col 6...

> I would use two text controls in a report. What is it about the placement
> of your subreports that is causing the [lname] control to appear below them?
[quoted text clipped - 15 lines]
> > Thanks in advance,
> > Susie

Reply to this Message