Form label as Value

[jasn_78]

WHat i am trying to do is return whatever i have currently in a label as a string field

Any ideas would be great

 

[boblarson]

For the form it is

Me.Caption = Me.YourTextboxNameHere

 

[jasn_78]

bob thanks but i mean more i want to return the text that currently is in the label

 

[boblarson]

How are you assigning the text to the label? I'm assuming that you are assigning the label's caption some sort of value.

You would just substitute Me.YourTextBoNameHere with Me.YourTextBoxLabelNameHere.Caption

And put the code in the form's On Current event.

 

[jasn_78]

thanks again bob it was for obtaining a subject header for an email

pity i cant add more reputation to ur name till i add to other lol

 

[boblarson]

thanks again bob it was for obtaining a subject header for an email

Glad to be able to help.

pity i cant add more reputation to ur name till i add to other lol

No worries there

 

[April15Hater]

What if somebody wanted to combine 2 values to obtain the value in the label? I know in Excel it's the "Indirect" Function

Here's my attempt:

Function PopulateFunctionTrackCombo()
Dim IntX As Integer

For IntX = IntX To 8
    If Me("chkTrackable" + Format$(IntX)) = True Then
'----------Next line is where I need to combine the txt and integer--------------
        strFunctionTrack = strFunctionTrack & ", " & Me("lblTrackable" + Format$(IntX))
    End If
Next IntX

End Function

Specifically- Me("lblTrackable" + Format$(IntX))