referencing field length in for loop

[priapus]

Uhhh...Fairly simple question, I just can't figure it out. I have this for loop where the first line is something along the lines of

For Each MyCharacter in Me![MyComboBox].Length

Only the Me![MyComboBox].Length is invalid syntax (there's no .length function). What's the correct way to reference a form field's length in a for loop?

 

[scking]

Dim intCtr As Integer
For intCtr = 1 To (Me.MyComboBox)
...
Next intCtr

Steve King

Growth follows a healthy professional curiosity

 

[dneufarth]

you can get the length with the Len function

Len(Me![controlname])


Dave

 

[scking]

Good catch Dave. I really meant to say:

For intCtr = 1 To Len(Me.MyComboBox)

Just another example of why it's important to have peer review or do testing.

Steve King
Growth follows a healthy professional curiosity