[AccessD] Forms

Jim DeMarco Jdemarco at hudsonhealthplan.org
Fri Apr 7 13:54:06 CDT 2006


Martin,

These are text boxes on multiple forms that you want to show/hide at one
time based on criteria?  I could conceive of using a collection (or
maybe custom collection class) to hold all refences to the text boxes.
Store it in a global variable and loop through it whenever the condition
is true.

Code might look like:

g_ocoll.Add txtMyTextBox
 If condition = True then
   for i = 1 to g_oColl.Count
      g_oColl.Item(i).Visible = True
   Next i 
 end if

Does that make any sense? 

Jim DeMarco

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid
Sent: Friday, April 07, 2006 2:29 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Forms

I havea text box set to visable no on many forms. I want to set them all
to visible if a condition is true for the application Cant seem to work
out how to do this from a single point.
 
Martin
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477
 
 


***********************************************************************************
"This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited.  If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message.  Thank You".
***********************************************************************************




More information about the AccessD mailing list