You could do this :

If IsNull(udb_rst!invoice_amount) Then line_amount = 0

That's how I get around it in my app



"Dan."  wrote in message
news:...
> have you tried:
>     if cstr$(text1.text)  cstr$(vbnullstring) then ...
>     if cdbl(text2.text)  cdbl(0) then ...
>     if cdate(text3.text)  cdate(0) then ...
> ?   in all these cases the if block will execute if the field is not null.
> 
> "Mac"  a écrit dans le message de
> news:koavc.28893$pt3.18454{at}attbi_s03...
> > Hi all,
> >
> > I am looking for help working around null values in
> > an update routine.
> >
> > My form provides users the opportunity to supply values
> > for some fields which may not be available at data entry time.
> > Whereas, some values are not always required I need to provide for blanks
>  in
> > some fields.
> >
> > My app includes three data types
> > Numeric
> > text
> > date
> > Can anyone help me with a work around.
> >
> > thanks
> >
> > Jim
> >
> >
---
þ RIMEGate(tm)/RGXPost V1.14 at BBSWORLD * Info{at}bbsworld.com

---
 * RIMEGate(tm)V10.2áÿ* RelayNet(tm) NNTP Gateway * MoonDog BBS
 * RgateImp.MoonDog.BBS at 6/8/04 4:56:51 PM