Print Page | Close Window

SettingLabels.mdb (intermediate)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=269
Printed Date: 09 Dec 2019 at 1:58am


Topic: SettingLabels.mdb (intermediate)
Posted By: Roger Carlson
Subject: SettingLabels.mdb (intermediate)
Date Posted: 22 Jul 2008 at 10:47pm
 
Please consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm - find out why here .
 

SettingLabels.mdb

This form gets the values of the labels from the Description of the Field in the table.

Method 1: shamelessly stolen from Duane Hookom, thanks Duane. It uses the fact that when a label is attached to a textbox, the label's properties are in the parent's collection. It requires labels be attached to the text box

Method 2: uses the Tag property of the both the textbox and label. You must put the same number in corresponding textbox/label controls. It does not require that the labels be attached to the text boxes.

Download
Access 97 (30 KB):
http://www.rogersaccesslibrary.com/forum/uploads/5/SettingLabels97.zip - uploads/5/SettingLabels97.zip
Access 2000 (26 KB): http://www.rogersaccesslibrary.com/forum/uploads/5/SettingLabels2k.zip - uploads/5/SettingLabels2k.zip


-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Print Page | Close Window