Moving a line control on a report ...

I have a report with a text box control which can grow as required
depending on the contents of the text box.

I also have a line control in the detail section which divides each
entry on the report.

What I would like to happen is that if the text box control grows then
the line moves as well so as the line splits each entry correctly.

The way it displays at the moment is that it divides after the first
line of text in the text box.

Any ideas please?

Many thanks,

Dan.

Stephen Lebans has a solution for this. See:
http://www.lebans.com/PrintLines.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dan Turner" wrote in message
m...
I have a report with a text box control which can grow as required
depending on the contents of the text box.

I also have a line control in the detail section which divides each
entry on the report.

What I would like to happen is that if the text box control grows then
the line moves as well so as the line splits each entry correctly.

The way it displays at the moment is that it divides after the first
line of text in the text box.

Any ideas please?

Many thanks,

Dan.

Dan,

I am guessing your line is vertical and you want it to grow with the text
box. Try this:

Private Sub Report_Page() 'The OnPage event
ctrlLine.Height = txtBox.Height 'of course change this to your line &
textbox names
End Sub

"Dan Turner" wrote in message
m...
I have a report with a text box control which can grow as required
depending on the contents of the text box.

I also have a line control in the detail section which divides each
entry on the report.

What I would like to happen is that if the text box control grows then
the line moves as well so as the line splits each entry correctly.

The way it displays at the moment is that it divides after the first
line of text in the text box.

Any ideas please?

Many thanks,

Dan.