Referencing field values in a label

[Ryan Langton]

With an .mdb, syntax of " = [fieldName] " for a label would cause the value
of the field to show up as the label. How do I do this with .adp?

Thanks,
Ryan

 

[Ryan Langton]

Hmmmm.. I thought this would be an easy one. Maybe my wording was
confusing. As an example, I have an .mdb Form that has a label (LabelA).
This LabelA has a value of "=[LastName] & ", " & [FirstName]". On the form
this displays as a regular label with a value of Langton, Ryan (if I was the
current record selected). Is there any way to do this with .adp? It
doesn't seem to be able to access the record values. "=[LastName] & ", " &
[FirstName]" shows up exactly as "=[LastName] & ", " & [FirstName]" on an
..adp form.

Ryan

 

[Brendan Reynolds]

I think you'll find that that 'label' is a text box formatted to look like a
label.

To do it with a label, you'd have to use code ...

Private Sub Form_Current()

Me!LabelA.Caption = Me!LastName & ", " & Me!FirstName

End Sub

--
Brendan Reynolds (MVP)

Hmmmm.. I thought this would be an easy one. Maybe my wording was
confusing. As an example, I have an .mdb Form that has a label (LabelA).
This LabelA has a value of "=[LastName] & ", " & [FirstName]". On the
form this displays as a regular label with a value of Langton, Ryan (if I
was the current record selected). Is there any way to do this with .adp?
It doesn't seem to be able to access the record values. "=[LastName] & ",
" & [FirstName]" shows up exactly as "=[LastName] & ", " & [FirstName]" on
an .adp form.

Ryan

With an .mdb, syntax of " = [fieldName] " for a label would cause the
value of the field to show up as the label. How do I do this with .adp?

Thanks,
Ryan

 

[Ryan Langton]

Thanks Brendan,
That code worked beautifully!

I think you'll find that that 'label' is a text box formatted to look like
a label.

To do it with a label, you'd have to use code ...

Private Sub Form_Current()

Me!LabelA.Caption = Me!LastName & ", " & Me!FirstName

End Sub

--
Brendan Reynolds (MVP)

Hmmmm.. I thought this would be an easy one. Maybe my wording was
confusing. As an example, I have an .mdb Form that has a label (LabelA).
This LabelA has a value of "=[LastName] & ", " & [FirstName]". On the
form this displays as a regular label with a value of Langton, Ryan (if I
was the current record selected). Is there any way to do this with .adp?
It doesn't seem to be able to access the record values. "=[LastName] & ",
" & [FirstName]" shows up exactly as "=[LastName] & ", " & [FirstName]"
on an .adp form.

Ryan

With an .mdb, syntax of " = [fieldName] " for a label would cause the
value of the field to show up as the label. How do I do this with .adp?

Thanks,
Ryan