First of all, I would like to thank the users of this group as I have
been using it as a great reference tool the past year while developing
my "biggest" application yet.
This one problem, I have not found a concise answer too, so I will re-
phrase it here.
Access 2000.
I have a report that can print up to 17 information blocks. Each
block is a Frame control, that containes roughly 20 various labels and
text boxes linked to data and or functions. These blocks are
statistics on various people.
If the statistic does not apply to a person, I hide everything about
the block. IF it applies, I place
the block on the report in the next logical spot. Here is the layout I
am using
1 2
3 4
5 6
7 8.....etc
In the reports Detail_ Format function, I call one of 2 routines.
Hidebox.:
- this lookes for each control on the form and hides it if the control
name starts with a certain suffix. ex.. if isnull(myfield) then
hidebox("Field1")
Placebox:
- I place each control with a specific top and left value wich is a
calculation of the spot number.
ex. if mid(control.name,6) = "MYNAME" then