I am trying to determine if an ADO field is nullable or required. I guess
since it is monday, my brain is not fully engaged. The field attributes
returns a value of 70 and I know adFldIsNullable is 20, but I need a clue on
how to see if the field is nullable.

TIA

Rob

To determine whether a particular value is part of a concatenated value, you
AND the two values together. If the result is 0, the value isn't part. If
the result is the particular value, it is.

Note that adFldIsNullable is actually 32 (20 is the hex value). Assuming
your value of 70 is also hex (so that it's 112 base ten), you can see that:

?112 And 32
32

so your field is nullable.


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Rob Diamant" <(E-Mail Removed)> wrote in message
news:eE%(E-Mail Removed)...
> I am trying to determine if an ADO field is nullable or required. I guess
> since it is monday, my brain is not fully engaged. The field attributes
> returns a value of 70 and I know adFldIsNullable is 20, but I need a clue
on
> how to see if the field is nullable.
>
> TIA
>
> Rob
>
>

Thanks Doug, you saved what hair I have left.

"Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:(E-Mail Removed)...
> To determine whether a particular value is part of a concatenated value,
> you
> AND the two values together. If the result is 0, the value isn't part. If
> the result is the particular value, it is.
>
> Note that adFldIsNullable is actually 32 (20 is the hex value). Assuming
> your value of 70 is also hex (so that it's 112 base ten), you can see
> that:
>
> ?112 And 32
> 32
>
> so your field is nullable.
>
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "Rob Diamant" <(E-Mail Removed)> wrote in message
> news:eE%(E-Mail Removed)...
>> I am trying to determine if an ADO field is nullable or required. I guess
>> since it is monday, my brain is not fully engaged. The field attributes
>> returns a value of 70 and I know adFldIsNullable is 20, but I need a clue
> on
>> how to see if the field is nullable.
>>
>> TIA
>>
>> Rob
>>
>>
>
>