DLookUp and Yes/No

[Telumendil]

When I try to get the value from a Yes/No field with a DlookUp function, the result I become is Yes if DLookUp is successful and No when criteria don't match any record ?

Does anyone know where this problem comes from ?

How should I do to get the value of the field ?

 

[lupins46]

How are you testing the result?
The possible results are True/Yes, False/No and Null (if there is no match).

 

[Telumendil]

Well, it is in a report, and I have both a checkbox and a provisory textbox (format yes/no) in it...

The result is Yes whether the field value is yes or no when the DLookUp criteria match a record and no when they don't...

 

[lupins46]

Post the control source for these controls.

 

[Telumendil]

=DLookUp("2004","[LBA Account]","[LBA Account].[LBA_Compte] =" & Compte_N°)

 

[Telumendil]

Just found out what the problem was...

Opening and closing brackets were necessary...

Correct code is :

=DLookUp("[2004]","[LBA Account]","[LBA Account].[LBA_Compte] =" & Compte_N°)

 

[Telumendil]

Thanks anyhow...