storing content of a variable

[maxbre]

can someone explain me why the storing of this variable is failing

var1 = Me!cod_personale.Column(2)

where cod_personale is a combobox (to be selected) in a form

I want to retrieve and store in a variable the content of a related field
from a query set as origin of the row for the combo box itself (which is originally used for another purpose)

is that too much confused? any help for this?



thanks

[RuralGuy]

What value is in the 3rd column that you are trying to store?

[maxbre]

an email address, I would say a string?

[RuralGuy]

It is a zero based reference so Column(2) is the 3rd column, right?

[maxbre]

yes, it is

[maxbre]

it says run-time error 94

[RuralGuy]

Where do you have that code?

[RuralGuy]

Try:
var1 = Nz(Me!cod_personale.Column(2))
Error 94 is Invalid use of a Null

[maxbre]

for some reasons, it's returning a null value...
still trying to understand why

[RuralGuy]

Just before that line put:
MsgBox Me!cod_personale.Column(2)
...and see what happens.

[maxbre]

it's exactly what I've done

in case of
MsgBox Me!cod_personale.Column(2)
it is returning an error 94

whilst in case of
MsgBox Nz(Me!cod_personale.Column(2))
is retuning a void message box

the strange thing is that for other column() the method is working fine!

can be something related to the content of that field (an email address that has some special characters in it like ...@....)?

[RuralGuy]

MsgBox "[" & Len(Me!cod_personale.Column(2)) & "]"
Debug.Print Me!cod_personale.Column(2)
then look in the immediate window for the Print.

[maxbre]

the msg box is returning []
the immediate window is printing null

[RuralGuy]

What values do you have in the Column Count and Column Widths properties? It sure looks like a Null now.

[maxbre]

ohhhh yes!
that was: the column count was not properly set !!!!!!!!!!!
now it works!

thanks a lot for helping me in this long debugging session
I've learned a lot, thanks again

m