ACCESS FEED: Re: [MS_AccessPros] Decreasing row height

Kamis, 05 Mei 2016

Re: [MS_AccessPros] Decreasing row height

Understood.

If I increase detail section height and the height of the four text boxes in each row, it works.

If I decrease detail section height and the height of the text boxes, blank space remains between rows. How can I get the rows to abut against each other with no blank space between rows?

Thanks, Steve

On 5/5/2016 10:31 AM, John Viescas JohnV@msn.com [MS_Access_Professionals] wrote:

Glenn-

You must also increase the Height of any boxes that display data on each row.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On May 5, 2016, at 4:27 PM, Steve thaw5@suddenlink.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Thanks Glenn and John for the advice. I am able to increase detail section height, but the height of the rows remains constant and space is inserted between rows. Decreasing detail section height decreases the space between rows. Seems to me that changing detail section height alone is not enough. Thoughts?

Thanks, Steve

On 5/4/2016 4:55 PM, John Viescas JohnV@msn.com [MS_Access_Professionals] wrote:

Steve-

You need to be changing the Height of the Detail section of the subform, not the Row Height.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

On May 4, 2016, at 10:49 PM, Steve thaw5 thaw5@suddenlink.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I'm using a continuous form to display rows of data. A command button
programmatically increases row height by 500 twips for each click.
Another button decreases row height by the same amount.

When the form opens, the rows are butted up against each other. When I
click the button to increase row height, the height increases and the
rows are butted up against each other. Here's the problem: when I click
to button to decrease row height, the height decreases but the rows no
longer abut each other. There is a blank white space between each row.
How do I decrease row height and get the rows to abut each other, i.e.,
no space between the rows?

Thanks.

Steve

------------------------------------
Posted by: Steve thaw5 <thaw5@suddenlink.net>
------------------------------------

------------------------------------

Yahoo Groups Links