Accessing empty/null Memo Fields in a Access 97
I ran into a similar problem while writing a COM object with
Visual Basic and I ran into a unusual error. I was checking for a null value on a memo
field but I kept getting an error that was saying I was trying to put a null
value into a scripting dictionary object so I put a breakpoint in the code
and when I put my mouse over the memo field it showed a value of ' ' but if
I moved my mouse back over it then it showed a Null value. Makes no sense
at all so I fixed it temporarily by putting a second null check, that did
work but I have no idea why it does that. Must be some bug with Memo
fields.
Quote:
>I have been trying to display information in a record set from some memo
>fields. If the records have information in these particular fields then I
>don't have any problems with the output. Now, if the memo fields are empty
>a scripting error occurs. It's like VB Script can not interepret these
>fields. When I run a IS NUll Query in Interdev's built in Query builder the
>fields come out with <binary> tag in the field. I've tried everything from
>checking the length of the field to using IsNull, IsEmpty. Everything
>returns as 0 or in other words "False" for the IsNull and IsEmpty
>Functions. Does somebody have a clue what is going on here?
