How can VBA learn whether a TextBox is bound?

  • Thread starter Thread starter Composer
  • Start date Start date
C

Composer

Sorry, I did try to find an answer in previous threads...

I'm writing a Sub which receives as a parameter
Me.Section(acDetails).Controls for a report.

My sub needs to do certain things with the bound TextBox controls, and
different things with the unbound TextBox controls.

How can it tell which of the TextBox controls is bound?

Thanks.
 
Composer said:
Sorry, I did try to find an answer in previous threads...

I'm writing a Sub which receives as a parameter
Me.Section(acDetails).Controls for a report.

My sub needs to do certain things with the bound TextBox controls, and
different things with the unbound TextBox controls.

How can it tell which of the TextBox controls is bound?
Click to expand...

For K = 0 To arg.Count - 1
If arg.Item(K).ControlSource = "" Then
' unbound
ElseIf Left(arg.Item(K).ControlSource, 1) = "=" Then
' expression
Else
' bound
End If
Next K
 
Back
Top