Remove blank line under combo box

S

Sandrine

Hello,
I have a report set this way in design view.The field FUNCTION is a text box
that can grow and shrink. On the same line as FUNCTION ,I have a combo box
COMBOBOX.Just underneath the combo box, I have a field TERMINATION that is a
text box that can grow and shrink.

FUNCTION COMBOBOX
TERMINATION

The problem is that FUNCTION grows to several lines, let's say 3 lines,
TERMINATION prints on the 4th line. This leaves too many blank lines between
the COMBOBOX and the TERMINATION. Like this

FUNCTION LINE1 COMBOBOX
FUNCTION LINE2
FUNCTION LINE3
TERMINATION

I want the termination to always print directly under COMBOBOX no matter the
size of FUNCTION.

FUNCTION LINE1 COMBOBOX
FUNCTION LINE2 TERMINATION
FUNCTION LINE3

Could anyone please help me fix my report?

Thanks
 
J

Jeff Boyce

Sandrine

?You have a combobox on a report? Reports are intended to provide a printed
output ... how do you use an interactive control like a combobox on printed
output?

Please describe what you want to achieve, rather than how you've attempt to
achieve ... ?something?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


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

Marshall Barton

Sandrine said:
I have a report set this way in design view.The field FUNCTION is a text box
that can grow and shrink. On the same line as FUNCTION ,I have a combo box
COMBOBOX.Just underneath the combo box, I have a field TERMINATION that is a
text box that can grow and shrink.

FUNCTION COMBOBOX
TERMINATION

The problem is that FUNCTION grows to several lines, let's say 3 lines,
TERMINATION prints on the 4th line. This leaves too many blank lines between
the COMBOBOX and the TERMINATION. Like this

FUNCTION LINE1 COMBOBOX
FUNCTION LINE2
FUNCTION LINE3
TERMINATION

I want the termination to always print directly under COMBOBOX no matter the
size of FUNCTION.

FUNCTION LINE1 COMBOBOX
FUNCTION LINE2 TERMINATION
FUNCTION LINE3


Make the function text box tall enough so that its bottom is
below the top of the termination text box.
 
S

Sandrine

Thanks a lot Marsh! It works like a charm!

Marshall Barton said:
Make the function text box tall enough so that its bottom is
below the top of the termination text box.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top