terpsichore
asked on
easy one (I hope): detecting null date value in combo box
Dear experts:
I have a combo box in a continuous form; one of its columns (index=7) contains an approval date, which may either be populated or null.
I am using conditional formatting on another field in the same record.
It is choking on the expression I am using to detect if that date is there or not.
I am using this:
Nz([Form]![cbopart_id].[co lumn](7),0 )<>0
Any ideas?
Thanks!
I have a combo box in a continuous form; one of its columns (index=7) contains an approval date, which may either be populated or null.
I am using conditional formatting on another field in the same record.
It is choking on the expression I am using to detect if that date is there or not.
I am using this:
Nz([Form]![cbopart_id].[co
Any ideas?
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hmmm, I'm not sure why that wouldn't work for you. Unless you're really referring to column 6 since the first column starts at 0.
Nz([Form]![cbopart_id].[co lumn](7),0 )<>0
does not work because values from comboboxes always are strings. Thus, Nz makes no sense here, and also the value would never be 0 but "0".
Jeffrey provided the solution. Alternatively, if you like:
Len([Form]![cbopart_id].[c olumn](7)) =0
/gustav
does not work because values from comboboxes always are strings. Thus, Nz makes no sense here, and also the value would never be 0 but "0".
Jeffrey provided the solution. Alternatively, if you like:
Len([Form]![cbopart_id].[c
/gustav
ASKER
thanks - you guys/gals were extremely helpful.
I am sure you can modify this to work in your db...
Database59.mdb