Invalid use of Null (A2k (9.0.4402) SR-1)

Topic

New Reply

Invalid use of Null

A2k (9.0.4402) SR-1

I

Reply | Quote

Replies

Are you sure that you are referring to the correct column in the combo box? Combo boxes are 0 (zero) based so the first column is Column(0). I have tried what you are doing and it is working for me.

hth,
Jack

Reply | Quote

John,

A yes/no field has 3 possible status.
Yes, No end Null
Null means that that field had not been set to yes or no. In fact the field is empty.
A way to avoid the empty status, is to assign a yes or no as default in the design of the table.
Another possibility is to use the Nz function.
blnActive = Nz(Me![lngTypeID].Column(31),0) ‘ for a default no
blnActive = Nz(Me![lngTypeID].Column(31),-1) ‘ for a default yes

Reply | Quote

In addition to the rest of the information you’ve been given, it would be a good idea to explicitly coerce the string value of the combobox column into a boolean by using the CBool() function around it.

Reply | Quote