Null value with memo field, error

27 Jan 2006 6:05 AM

toufik

Hi,
In my table(ms-access) I've a memo field whih is not required, and allow
zero length to true.
I've in a vb.net form, a textBox bound to this field,
- I can leave it as NULL and save.
- I can fill a value in it and save
- but when it has a value and I empty it I've an error if I save
(dataadapter.update)

Any Idea please.
Thanks.

27 Jan 2006 6:22 AM

Cor Ligthert [MVP]

Toufik,

How do you "empty" it?

Cor

Show quoteHide quote

"toufik" <tou***@hotmail.com> schreef in bericht
news:e6JzjewIGHA.3700@TK2MSFTNGP15.phx.gbl...
> Hi,
> In my table(ms-access) I've a memo field whih is not required, and allow
> zero length to true.
> I've in a vb.net form, a textBox bound to this field,
> - I can leave it as NULL and save.
> - I can fill a value in it and save
> - but when it has a value and I empty it I've an error if I save
> (dataadapter.update)
>
> Any Idea please.
> Thanks.
>
>

27 Jan 2006 7:59 PM

toufik

I empty The texybox which is bound to it , means delete all its countent.
Thanks

Show quoteHide quote

"Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message
news:ev7G6nwIGHA.3000@TK2MSFTNGP14.phx.gbl...
> Toufik,
>
> How do you "empty" it?
>
> Cor
>
> "toufik" <tou***@hotmail.com> schreef in bericht
> news:e6JzjewIGHA.3700@TK2MSFTNGP15.phx.gbl...
> > Hi,
> > In my table(ms-access) I've a memo field whih is not required, and allow
> > zero length to true.
> > I've in a vb.net form, a textBox bound to this field,
> > - I can leave it as NULL and save.
> > - I can fill a value in it and save
> > - but when it has a value and I empty it I've an error if I save
> > (dataadapter.update)
> >
> > Any Idea please.
> > Thanks.
> >
> >
>
>

30 Jan 2006 3:23 PM

Paul Clement

On Fri, 27 Jan 2006 14:59:47 -0500, "toufik" <tou***@hotmail.com> wrote:

¤ I empty The texybox which is bound to it , means delete all its countent.
¤ Thanks
¤

What is the exact error message?

Paul
~~~~
Microsoft MVP (Visual Basic)