RE: test for ...expression that has no value

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi :-)

> I've tested the values in the immediate window and it's clear that the error
> occurs when because one of the fields "has no value" and although there is
> no doubt that is true, I'd prefer a zero instead of an error.
>
> I have tried nz, isnull, and isempty.

Im in a similar situation.
I have a function which is called from a textbox on a form.
The function takes the value of a field form my query
and does some caluclations based on that value.

However, when the field appears to be empty,
the textbox (and i guess the function) returns an "#error"

I slapped in an error handler in the function
but that didnt trap the error either.

any suggestions?
cheers

.

Relevant Pages

  • Re: Pls Help - "between" Criterea returning no results
    ... I have done that and it returns the value exactly as I have it entered in the textbox ... i.e I entered "30000" in the textbox it returned "30000" in the immediate window ... Press ctrl-g. ... I also tried changing the text boxes to Combo boxes populating ...
    (microsoft.public.access.queries)
  • Re: AfterUpdate Event not Running
    ... immediate window, as you suggested. ... Jim ... > txtVenName isn't an object until the userform is loaded. ... >> I went into a Userform and selected a textbox ...
    (microsoft.public.excel.programming)
  • Re: vb newbie help
    ... To move the insertion point to the end of the textbox (and thus scroll ... to the Immediate Window. ...
    (comp.lang.basic.visual.misc)
  • inability to change unbount textbox default value programmatically
    ... I'd like to be able to make the current value of a textbox on a form ... Debug.Print "orig", Me.tbxYear.DefaultValue ... default value change shows up in the immediate window, ...
    (microsoft.public.access.formscoding)