Carlo,
Please include the previous posts in your reply so we know what you are referencing. Also, it would have been great if you would have mentioned that you tried the Can Shrink and why it didn't work. It would save some back and forth in attempting to provide some assistance.
Is the spacing of the 60 normalized fields the same vertically or will this vary? If it's the same, you could loop through the controls and increment the number of fields with values and multiply the spacing by the increment and add to the top most control's top position. You could also make all the control invisible and use the Me.CurrentX, Me.CurrentY, and Me.Print methods to display the values from the fields.
Duane Hookom MVP
MS Access
From: MS_Access_Professionals@yahoogroups.com
To: MS_Access_Professionals@yahoogroups.com
Date: Mon, 17 Nov 2014 12:29:48 -0800
Subject: RE: [MS_AccessPros] Resize a report vertically if the fields are empty
I know well the properties can shrink and can grow
my table is normalized, the mode Can Shrink has already been tried and it does not solve all the situations
The problem is not the 60 fields, I could have a lot less or a lot more.
As shown is an example, it seems a good way, ask for help, because maybe I'm missing something.
Try to analyze the code, Thanks
Please include the previous posts in your reply so we know what you are referencing. Also, it would have been great if you would have mentioned that you tried the Can Shrink and why it didn't work. It would save some back and forth in attempting to provide some assistance.
Is the spacing of the 60 normalized fields the same vertically or will this vary? If it's the same, you could loop through the controls and increment the number of fields with values and multiply the spacing by the increment and add to the top most control's top position. You could also make all the control invisible and use the Me.CurrentX, Me.CurrentY, and Me.Print methods to display the values from the fields.
Duane Hookom MVP
MS Access
From: MS_Access_Professionals@yahoogroups.com
To: MS_Access_Professionals@yahoogroups.com
Date: Mon, 17 Nov 2014 12:29:48 -0800
Subject: RE: [MS_AccessPros] Resize a report vertically if the fields are empty
I know well the properties can shrink and can grow
my table is normalized, the mode Can Shrink has already been tried and it does not solve all the situations
The problem is not the 60 fields, I could have a lot less or a lot more.
As shown is an example, it seems a good way, ask for help, because maybe I'm missing something.
Try to analyze the code, Thanks
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar