Brackets Galore

[Swamp Thing]

I have a combobox in a form. I also have a textbox that shows the first element in the combobox's list, i.e.

=[Combo1].[Column](0,0)

What happens is that each time I switch from design to form view and back to design, I see one more pair of brackets around the zeros, so that I soon end up with:

...[Column]((((((0,0))))))

Not that it affects the operation, but it makes one wonder.. what is happening?

 

[SydneyGeek]

Haven't seen that before but do you really need the Column (0,0)? I've only ever used =Combo1.Column(0) to get the first column -- in fact, if yo want the first column, you only need =Combo1 because field 0 is the default bound column.
Dunno if I've missed something here...

Denis

 

[Swamp Thing]

If we use only one zero in the brackets then what we get is the currently selected row. What I wanted to reference was the top row, irrespective of selection. The idea was to make sure that the combobox would start up with the top item instead of Null, by setting the combo's default value to its own top value:

Combo1.Column(0,0) ==> Combo1's Default Value

This had the desired effect, but the brackets would increase when entering design mode as I described.
To understand this phenomenon, I tried putting the formula into a separate textbox's Value property, and the same result was observed.