Binding Label controls to data

Similar Threads:

1.Moving focus from bound control to unbound control causes bound control changes to be cancelled

How can I trap this and keep it from happening?

2.Source Control data binding to ActiveX control property

A third-party ActiveX control ctDropDrop has an integer Value property that 
is the number of days from 1/1/1900, and my table has a field ScheduleDate 
with type Date.  Can I use a form's Source Control to bind Value to 
ScheduleDate, perhaps using conversion routines, or do I use event 
procedures to copy the date from/to the form text box and ActiveX property 
value?  I'm guessing the answer is the latter, but want to make sure I'm 
using the simple approach.

Best,
Christopher

3.Code to refer to the caption of a label bound to a control

I use controlstag property and BeforeUpdate code to validate missing data 
on a form. How can I edit the MsgBox below to show the caption of the label 
that bound to the control, instead the name of the control (ctl.Name) 
that currently used? Thanks. - Kurt

###

Private Sub Form_BeforeUpdate(Cancel As Integer)

Dim ctl As Control

    For Each ctl In Me
         
        If ctl.Tag = "*" Then
            If IsNull(ctl) Or ctl = "" Then
                MsgBox "You must complete the required field '" & " " & 
ctl.Name & " " & "' before you can continue.", vbCritical, "Required Field"
                ctl.SetFocus
                Cancel = True
                Exit Sub
            End If
        End If
    Next
    Set ctl = Nothing

End Sub

4.Bound Control - make respective label use field desc

I have a form with bound controls with respective labels.

Each text box is name "txt"+Data Source Name (field name)

Each respective label in captioned as "lbl"+Data Source Name

I would like to loop through the form, grab the text box's data source
property and set it's corresponding label's caption property to the data
source property.

Any ideas?

Thanks.

5.To control textbox according to label values ( label should be controlled from another textbox )

Hi,
     I want to link textbox and label in access report. I am making a
report in which i want fields value in Week 1 to Week52 to be
coloured
according to field value in WEEK. If WEEK value is 45 them all fields
from Week1 to Week45 should be coloured if they have some value.

WEEK (LABEL)    ___any value say 45_____(TEXTBOX)


1 (LABEL)         should be coloured if label value is =or less than
WEEK text value and textbox
                        of 1 is not empty. (can have value say H, M ,
W etc.)
2                       should be coloured if label value is =or less
than WEEK text value and textbox
                         of 2 is not empty
3                                         -
4                                         -
-
-
45                     should be coloured if label value is =or less
than WEEK text value and textbox
                         of 45 is not empty

-
-
52                     So values upto 1 to 45 should be coloured in
report if not empty.


                        Can anyone help me regarding this problem.

6. Format record bound charts in Access, data labels and colors

7. Label Bound to another Label

8. Non-bound control on bound-form