隐藏报告和行中的行消除空格，但仍然引用这些值 [英] Hide rows in report & eliminate whitespace, but still reference the values

问题描述

我基本上试图在Access报告中复制Excel。


我的查询中有30多行数据，我需要所有30多行来执行某些操作在VBA中进行计算，将30多行提取到12行。


我能够获取数据并执行计算并通过设置Height = 0来隐藏不需要的行，但他们仍占用空白。


我试图将每行的Visible属性设置为False，但是由于某种原因（设计？）我无法在VBA中引用它们我的IF-THEN语句有效。


基本上，我想要的只是我的12行数据，没有空格。

解决方案

自从我在访问中进行任何真正的开发工作以来已经有一段时间了。

如果将width属性设置为0会发生什么。我认为这将实现什么你需要

只是重新阅读你的问题，我发现你实际上是在试图隐藏整行，而不仅仅是行中的某些字段。 Hmmmm

右。我可以隐藏报告上的行（即它们是白色）但它们仍然占用空间。我尝试过Move方法，Visible，Left，Top，Width和Height属性，但没有任何工作。这让我疯了......

I''m basically trying to replicate Excel in an Access report.

I have 30+ rows of data from my query, and I need all 30+ rows to perform some calculations in VBA to distill the 30+ rows down to 12.

I''m able to get the data and perform the calculation AND hide the unwanted rows by setting their Height = 0, but they still take up whitespace.

I''ve tried to set the Visible property on each row to False, but then I can''t reference them in VBA for some reason (by design?) and none of my IF-THEN statements work.


Basically, all I want are my 12 rows of data in a nice stack with no whitespace.

解决方案

Its been a while since I done any real development work in access.
What happens if you set the width property to 0. I would think that that will achieve what you require

Just re-read your question and I see that you are actually trying to hide entire rows not just certain fields in the row. Hmmmm

Right. And I can "hide" the rows on the report (i.e. they are "white") but they still take up space. I''ve tried the Move method, the Visible, Left, Top, Width and Height properties but nothing is working. It''s been driving me nuts...

这篇关于隐藏报告和行中的行消除空格，但仍然引用这些值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！