[AccessD] Stacking Controls on an Access 2007 Report

Hi Brad,

In the past I have stacked many controls/images/objects on top of each other in Access Forms - I only ever had one visible of them at a time though.  I would imagine the upper limit would be the default limit of "# of controls on a form".  Be-aware that when you add a control, and then delete it, it is still included in the count.  You can get around this by creating a new form and importing the current objects/controls into it.

To control the visibility of each object (or group of objects) I found it easiest and best to use the .tag property for each object.  That way you can turn on/off visibility of a whole set of controls with a single bit of code.

In very basic terms user A gets to see all objects with a tag value of 1, User b = tag 2 etc.  You can make these rather complex but using 2X1A or whatever and then using MID etc to determine which character Key does what.

Hope that helps a bit.

Cheers
Darryl.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Monday, 14 May 2012 11:22 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Stacking Controls on an Access 2007 Report

All,


I am building an Access 2007 Report that is going to include a number of Images (jpg files).

These jpg files do not have explanations, so I am planning to use Access Report Labels to add descriptions to the Images.  Because of the size of the Images, I am planning to simply add the Labels on top of the images (near the bottom of each image). 

This seems to work nicely in my initial tests.

In a prior life, I worked with a software package that often had problems with controls that shared the same space.  It appears that this is not a problem with Access, but I just wanted to make sure that I am not heading for trouble.

Thanks,
Brad